upsize access 2002 to sql 2000 with varchar not nvarchar

[saso]

Does anybody know a trick to do it? Even if it's
unsupported I wouldn't mind.
I found a bug reported against access 2000 that upsizing
wizard converts text to nvarchar instead of varchar. And
it's written there that it's fixed in access 2002, but it
isn't. I still get everything in nvarchar!
Can somebody please help?

 

[BJ Freeman]

I would suggest that after you create the DB in SQL server, you create a
script for just the views and stored procedures and indexes.
then open the script and do a global replace.
then delete the SQL DB.
using the Enterprise manager, create a Blank DB.
then open the ADP and import the tables from mdb.
using the query analyzer, set it to the new db and run the script.