Upsizing wizard

[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?

 

[Tony Toews]

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"

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

 

[Dick Bosworth]

I'll have a look at my records.

Many thanks

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

 

[Dick Bosworth]

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.

 

[Dick Bosworth]

OOPS I didn't read your response in its entirety. I just downloaded the
migration assistant.

 

[Joan Wild]

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

 

[Gil Lapid Shafriri]

You may want to try SSMA Access that should be abbeter tool the the office
upsizing wizard.

http://www.microsoft.com/sql/solutions/migration/default.mspx


It fixes all kind of problems with the office upsizing wizard. One of them
is date values out of SQL Server range.

Gil