var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Importing MS ACCESS db into MS Sql Server 2000
I have a ms access database on say c:\database.mdb
I have a sql server 2000 running too.
I want to use some command line tool , like isql or osql to convert this database into a sql sever database.
How can I achieve this ?
Thanks in advance.
You can use SQL server's DTS tool to import MS access database to SQL server.
If not you can use MS Access Upsizing wizard to upgrade to SQL server.
As I mentioned , I need to do it through command line.
If you give me a sample code , that would be great.
After creating the DTS package run DTSRUN utility from command prompt to execute the package. Refer to SQL server books online for DTS topics and DTSRUN topic for more information.