EMPTY TABLE AFTER UPSIZING TO SQL

[TompIfe]

Hi,
I have an Access database that has a table which cannot be upsized to SQL
Server (the table is empty after upsizing).
Any suggestions on how I may procede to get the Access table into the SQL
database?
Kind regards,
Tom

 

[Sylvain Lafontaine]

A lot of potential problems with the Upsizing Wizard could block the copying
of the data to the newly created table; for example an out of sequence
insert command in relation to a foreign key relationship. I suggest that
you copy the data yourself with an Insert command and forget about this.

Also, the official newsgroup for upsizing problems is
microsoft.public.access.sqlupsizing

 

[Sylvain Lafontaine]

You could also give a shot with the the SQL Server Migration Assistant for
Access (SSMA-A) instead of the Upsizing Wizard:

http://www.microsoft.com/downloads/...b4-c914-4ac7-b2f3-d25fff4e24fb&displaylang=en

 

[Tony Toews [MVP]]

I have an Access database that has a table which cannot be upsized to SQL
Server (the table is empty after upsizing).

One possible problem is a date outside of SQL Servers smalldatetime
data type valid date range. 1900-01-01 to 2079-06-06. This happens
because of fat fingers on the keyboard and the users not having the
system display the century.

In one table of 100K records I found 12 examples of this problem.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[TompIfe]

Hi,
It works with the SQL Server Migration Assistant, but I get a lot of errors
and warnings that I will must work on.
Thank you for your assistance,
Tom