Error 8152: String or binary data would be trucated when using upsizing wizard to SQL Server

M

Martin Rajotte

Hi,

While running the upsizing wizard to upsize an access 2003 db to SQL Server
2000 I get the following error:

Server Error 8152: String or binary data would be truncated.
Server Error 3621: The statement has been terminated.

It looks like a field in the resulting table is not large enough to handle
the data being inserted but I have no control over this since the wizard is
creating the table...

How can I find out what is causing the problem? Any idea on how troubleshoot
or fix it are welcome.

Thank you for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top