EMPTY TABLE AFTER UPSIZING TO SQL

  • Thread starter Thread starter TompIfe
  • Start date Start date
T

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
 
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
 
TompIfe said:
I have an Access database that has a table which cannot be upsized to SQL
Server (the table is empty after upsizing).
Click to expand...

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/
 
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
 
Back
Top