It is not unusual for Access to refuse to send any of the data to SQL server
when a problem is encountered during the transfer (e.g., a value in your
Access table is incompatible with the format of your SQL table). Problems
could be with nulls, zero-length strings, etc.
You'll probably have to spend some time figuring out where the problems are.
You could try upsizing the tables one at a time - that might help you
pinpoint which tables are problematic.
I don't use the upsizing wizard - I prefer to use DTS from the SQL Server
side - but you'll still have to resolve any incompatibilities between the
two databases.
Bob
-----Original Message-----
From: John Fix 3rd [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 30, 2000 1:35 PM
To: CF-Talk
Subject: RE: Upsizing to SQL Server from Access
Here's a weird one. I'm upsizing two different Access databases into one
SQL Server database. One of the databases upsized properly and transferred
the tables and data, but the other database only transferred the tables.
Any idea why one would move data and the other would not? I'm transferring
from the same machine using the same user.
Thanks!
John
www.cornells.com
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
