DTS from SQL2000 to MS Access

[irapuri78]

Could you pl tell me how to transfer data from SQL2000-MS Access
I need it urgently , Can somebody help with the steps, I really appreciate it
thanks

[caveatashish]

Could you pl tell me how to transfer data from SQL2000-MS Access
I need it urgently , Can somebody help with the steps, I really appreciate it
thanks

start dts wizard in the source server select mdb driver browse to the access file and select it, if that access file is password protected specify the username as admin and the password in the advance tab,

select the target server next and follow the instruction

[t3chn0n3rd]

I have gone from Ms Access to Sql sever , But never the opposite direction

[yaad]

Go to Import and Export (DTS) wizard through strat menu which is always placed with sql200.
First thing you should remember is you have to give two thingd.;
1 datbase source (From what to copy)
2 Destination (where to copy)

Using DTS you can copy tables from access to acess,sql,notepad and so on....In same way from other database to other or same.

Step first.
Give the data source of dastination.
for you..
select Microsft oledb provider for sql server.
Give authiountation(password)
select database name.

step second
Give the datasource information where to copy.
in your case
Select "Microsoft Access"
After this select access database .

If you want to copy in new database then right click on open dialogbox and click on mdb file like creating text file.

Now finally seletc the tables you want to copy and then next next next and watch.
Finished..