Software

Ask something
Discussion Locked

Upsizing Access 2003 to SQL

0 helpful
5 replies

by c-mackenzie

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to upsize a database with 6 tables from Access 2003 to SQL version 8. 5 of the tables upsize and link to the SQL database without any problems but one of the tables returns "table was skipped, or export failed" error. I have given the table a primary key, there are over two hundred fields in this rogue table(is there a limit on the number of fields you can upsize into SQL ???) I've tried importing the table structure only to no avail. All field names are ok for SQL. Any ideas or things to try, please let me know!

Many thanks

Colin

5 replies

by vinnyd

Since SQL 8 is kind of old and Access 2003 is newer you may have some field that is not going to convert.

Use the SQL Manager and create the table in SQL

Export the data from Access to a comma delimited file

Import the csv file into SQL

by mdv3441

Maybe try the equivalent of DTS to import the erroring tables. A more specific error message may present itself.

This discussion is closed to new replies.