Article ID: 200405 - View products that this article applies to.
This article was previously published under Q200405
This article has been archived. It is offered "as is" and will no longer be updated.
Advanced: Requires expert coding, interoperability, and multiuser skills.
This article applies only to a Microsoft Access database (.mdb).
If you upsize a table that has a field with a data type of Text, the Upsizing Wizard will map the type to the Microsoft SQL Server 7.0 nVarChar data type instead of the VarChar data type. This happens even though the Upsizing Wizard report indicates that the column was mapped to VarChar.
Manually change the data types on SQL Server to the data type that you want.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was fixed in Access 2002.
Steps to Reproduce Problem
For more information about the Upsizing Wizard, click Microsoft Access Help on the Help menu, type use the Upsizing Wizard in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.