December 20, 2005 at 11:09 am
We are upgrading all of the Access 2000 databases to SQL Server 2000. I have been using the DTS Import Wizard to import the data. Some of the Tables in the Access database will have the Access limit of 255 columns. Some of these columns are of the memo data type. I have had occasions where i was given an error that said the following:
"Cannot create a row of size 8470 which is greater than the allowable maximum size of 8060"
Is there another way to import all of the data at once instead of grabbing all but the memo fields and then updating each and every record to add the data from these fields?
Also It seems that there is a problem in a number of the column names as the identifiers will sometimes start with a number 1-9, and soem are simply only numbers with no other characters. When I look at the table in design view, I can see that when the tables are created that they have square brackets around them. Will these still work or should I rename them now? Another problem is that one of the tables has a column with a dash in the middle of the name. The Wizard made me change that before it even created the table. Are dashes allowed in the identifying name of columns?
December 21, 2005 at 7:22 am
Have you considered using the "Upsizing Wizard" for Access (http://www.microsoft.com/technet/prodtechnol/sql/2000/Deploy/accessmigration.mspx)? We migrated from Access to SQL Server 2000 a few years back and tried both approaches (DTS and Upsize Wizard). When we migrated the production data, we found it easier to use the Upsize Wizard.
Norene Malaney
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply