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 |
|
gurusamy.senthil
Yak Posting Veteran
65 Posts |
 Posted - 2009-09-18 : 07:13:29
|
| Hi All,I have my legacy data in MSAccess. I need all the tables in MSACCESS (with data) to convert into MSSql. I tried the export option available in MSAccess and exported into MSSql. Some tables copied thje data and but some not. Getting a over flow error. Can you please help me to convert access db into mssql?Thanks,Senthil .G |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2009-09-18 : 08:42:24
|
| It's easier to import from access using SSIS or the import Wizard. The best way is to create the tables on SQL Server first, with the correct data types in SQL. For example, in Access you have "Text", but in SQL Server you would probably want varchar(xx). Also, there are dates in Access that SQL won't recognize, like "01/01/1234". It might be a lengthy task, but it's probably your best bet.JimEveryday I learn something that somebody else already knew |
 |
|
|
|
|
|
Move tables from MSAccess to MSSql