Upsizing wizard

[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

 

[Tony Toews]

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?

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

 

[John]

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