General discussion

Locked

Upsizing Access 2003 to SQL

By c-mackenzie ·
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 conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by VinnyD In reply to Upsizing Access 2003 to S ...

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

Collapse -

by c-mackenzie In reply to

Poster rated this answer.

Collapse -

by mdv3441 In reply to Upsizing Access 2003 to S ...

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

Collapse -

by c-mackenzie In reply to

Poster rated this answer.

Collapse -

by c-mackenzie In reply to Upsizing Access 2003 to S ...

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums