F
Frank
I'm trying to upsize a table from Access 2002 to SQL Server 2000 using
the Upsize Wizard in Access. I keep getting the following unhelpful
error message :
Table was skipped or export failed.
The weird part is that I can use the Export utility to create the
table on the SQL Server and it works perfectly. It creates the new
table complete with indexes and data. This also tells me that the DSN
I'm using for both the Export and the Upsize Wizard is set up
properly, otherwise the export wouldn't have worked.
The table is also just a standard, no-nonsense test table I created.
It has 2 text fields and a primary key. I created a few test records
with just regular text in the fields. So I strongly doubt that it is a
data issue.
Any ideas?
Thanks - Peter
the Upsize Wizard in Access. I keep getting the following unhelpful
error message :
Table was skipped or export failed.
The weird part is that I can use the Export utility to create the
table on the SQL Server and it works perfectly. It creates the new
table complete with indexes and data. This also tells me that the DSN
I'm using for both the Export and the Upsize Wizard is set up
properly, otherwise the export wouldn't have worked.
The table is also just a standard, no-nonsense test table I created.
It has 2 text fields and a primary key. I created a few test records
with just regular text in the fields. So I strongly doubt that it is a
data issue.
Any ideas?
Thanks - Peter