Upsizing wizard

  • Thread starter Thread starter Dick Bosworth
  • Start date Start date
D

Dick Bosworth

I'm trying to use the upsizing wizard to import data to sql Server Express.
All of my tables are not imported, and the following error message shows up
on the report. "tbl skipped or export error"

Anyone know what might be wrong?
 
Dick Bosworth said:
I'm trying to use the upsizing wizard to import data to sql Server Express.
All of my tables are not imported, and the following error message shows up
on the report. "tbl skipped or export error"
Click to expand...

Chances are there are a few records with dates accidentally entered
with the century before 1800 or after 2100. SQL Server's default date
format lies somewhere in those boundaries and the Upsizing wizard
doesn't handle those properly.

There is a new tool from the SQL Server group.
SQL Server Migration Assistant for Access (SSMA Access)
http://www.microsoft.com/sql/solutions/migration/default.mspx

This tool may do a better job of handling 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
 
I'll have a look at my records.

Many thanks

Tony Toews said:
Chances are there are a few records with dates accidentally entered
with the century before 1800 or after 2100. SQL Server's default date
format lies somewhere in those boundaries and the Upsizing wizard
doesn't handle those properly.

There is a new tool from the SQL Server group.
SQL Server Migration Assistant for Access (SSMA Access)
http://www.microsoft.com/sql/solutions/migration/default.mspx

This tool may do a better job of handling 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
Click to expand...
 
I checked the dates, and they are all valid. Any other suggestions. Your
link wants me to purchase SQL Server. I'm using the free express addition.
 
OOPS I didn't read your response in its entirety. I just downloaded the
migration assistant.
 
Other possibilities:

- some field's default value property is set to a function, or something
that the wizard can't find the equivalent.
- the table is hidden
 
Back
Top