Upsize MSAccess table to SQL using SP
Database
2
Posts
2
Posters
0
Views
1
Watching
-
Hi, am trying to upsize certain tables in MS Database to SQL.I tried the upsizing wizard,but for certain tables its giving me errors like "unable to drop table". Is their any stored procedures which will help us to upsize the ables to SQL?
Create the tables in SQL then import the data from the MDB. If you have multiple tables with constraints, either import the data in the correct order, or temporarili remove the constraints.
A treat for all down voters...[^] "you can't forget something you never knew..." M. Du Toit