Access 2002 to SQL Server 2000

[JoeT]

I'm trying to upgrade an Access 2002 database to SQL
server 2000 using the Access Upgrade Wizard.

First I moved the database to another computer that has
Access 2003, and from there used the upgrade wizard

The wizard upgrads 6 or 7 out of 8 tables, but it always
skips one or two tables. If I try to import the mdb table
into the new ADP I get an error message "overflow"

Any idea why the wizard keeps skipping these two tables?
The report at the end of the upgrade does not say why the
tables were skipped.

Thanks for your help!
Joe
PS, Microsoft rocks!!!

 

[david epsom dot com dot au]

The report at the end of the upgrade does not say why the

tables were skipped.

Perhaps you have a data error? Maybe an invalid Date?

One option is to try or buy a third party product with
better reporting:

http://www.ssw.com.au/ssw/UpsizingPRO/

(david)