Convert nvarchar to varchar

  • Thread starter Thread starter Ron Hinds
  • Start date Start date
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!
 
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.
 
Back
Top