Access to SQL Server

[Brian Scott]

Hi,

Can anyone offer any advice on migrating data programatically from Acces to
SQL Server? I want the datatypes in the SQL Server version of the data to
reflect SQL Server types such as using Varchar instead of NVarchar. Is this
possible without using the Enterprise Manager?

 

[Steve Schroeder]

I imagine, without using Enterprise Mgr. you will have to use some
combination of ADO and DDL to explicitly specify Varchar, or other data
types you'll want to use.

Migration tools are generally speaking a waste of time and effort.

 

[Val Mazur \(MVP\)]

Hi,

You could use DTS to import data from Access to SQL Server. If you cannot
use DTS, then you could do a bulk import using next example. Regarding
datatypes - which datatypes are in a tables depends on what datatype you
specified during creating of the table(s) through Enterprise Manager or
through the DDL script, so control is in your hands.