Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sirmilt
Starting Member
49 Posts |
 Posted - 2010-11-09 : 19:47:02
|
| Is there a way that I can convert an Access 2000 table into a table in SQL Server 2008 Express R2?The Access table has only four fields, one auto number and three text fields but it has almost 100 records thatI want to try to avoid re-entering the SQL Server table, which I have aleady designed and added to my project.Does anyone have any suggestions?Milt |
|
|
sirmilt
Starting Member
49 Posts |
Posted - 2010-11-10 : 17:43:49
|
| I checked and found a simple answer.There is an Import/Export Data node in the SQL Server 2008 R2 node of "All Programs" and it worked perfectlyMilt |
 |
|
|
kriseide
Starting Member
2 Posts |
Posted - 2010-12-07 : 11:29:07
|
quote:
Originally posted by sirmilt
I checked and found a simple answer.There is an Import/Export Data node in the SQL Server 2008 R2 node of "All Programs" and it worked perfectlyMilt
Hi!I'm just using this tool but I have trouble with some text fields that are not recognized during the process. These text fields are associated to a "strange" type 130, instead of to a varchar or similar data type. I have started a new topic in http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=153891 |
|
|
|
|
|
|
Convert An Access Table