 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / SQL Server / ADP / January 2004Convert nvarchar to varchar
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. >-----Original Message----- >Is there a way to do this with DTS or another tool? I have an Access 97 app [quoted text clipped - 5 lines] > >. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.