Convert nvarchar to varchar

R

Ron Hinds

Is there a way to do this with DTS or another tool? I have an Access 97 app
and I'm converting the BE to SQL2K. The upsize tools all want to convert my
Access Text fields to nvarchar, but when I link them back to A97 this causes
problems. I manually changed a field to varchar and the problem disappeared.
But I have several hundred tables so I need a way to do this automatically.
TIA!
 
S

SFAxess

If you haven't already, I would suggest posting this in a
SQL Server newsgroup. It sounds like getting advice from
a seasoned SQL Server DBA would be the safest way to go.
 

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

Similar Threads

Data Type nvarchar or varchar 13
Convert nvarchar to date 12
Changing an existing field to VarChar type also changes the fieldwidth 2
upsize access 2002 to sql 2000 with varchar not nvarchar 1
Convert to string/varchar? 1
Syntax error converting varchar 1.8 to a column of datatype int. 6
nvarchar vs varchar in .net application 4
concatenate date and time 4

Top