I'm trying to move several Access Tables from a moderate sized database to SQL Server 2000. Most of the tables will transfer using the Upgrade Wizard in Access 2003, however, there are a couple of tables that will not transfer. The wizard reports at the end of the upgrad, "table skipped" or "overflow"
I cannot find in the help section why this happens. I would appreciate any help you send my way.
Thanks,
Joe| I'm trying to move several Access Tables from a moderate sized database
| to SQL Server 2000. Most of the tables will transfer using the Upgrade
Wizard
| in Access 2003, however, there are a couple of tables that will not
transfer.
| The wizard reports at the end of the upgrad, "table skipped" or "overflow"
--
Hi Joe,
One known issue that causes the "table skipped" error are column names that
contain symbols such as quotes, commas and slashes. SQL Server doesn't
support all symbols for column names. If you rename such "odd" column
names, the upsize wizard should work again. Also a known issue is:
ACC2000: Tables Not Upsized When Query or Table Name Contains Apostrophe
http://support.microsoft.com/?id=216218
If all else fails, you can use Data Transformation Services (DTS) to export
to SQL Server:
ACC2000: How to Use Data Transformation Services (DTS) to Export Data from
a Microsoft Access Database to a SQL Server Database
http://support.microsoft.com/?id=250616
Hope this helps,
--
Eric Cárdenas
SQL Server support
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment