General discussion
February 2, 2006 at 04:02 AM
c-mackenzie

Upsizing Access 2003 to SQL

by c-mackenzie . Updated 20 years, 7 months ago

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

This discussion is locked

All Comments