Upsizing wizard

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

I am using the upsizing wizard to move a table from access 2000 to sql
server. The table does not get exported and all I am getting is a 'Table was
skipped, or export failed' error in the upsizing report. What is going on?

Thanks

Regards
 
John said:
I am using the upsizing wizard to move a table from access 2000 to sql
server. The table does not get exported and all I am getting is a 'Table was
skipped, or export failed' error in the upsizing report. What is going on?
Click to expand...

FWIW I doubt very much most the SQL Server folks know about this
problem.

See my Random Thoughts on SQL Server Upsizing from Microsoft Access
Tips page at my website.

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
 
Hi Tony

It appears that its my date/time fields. This is mentioned on your page but
the problem is I am storing only the time part as short time in the fields.
How do I fix this in this case i.e. when the date part was never entered in
the fields? In a separate message I have posted some sample values.

Thanks

Regards
 
Back
Top