Data Migration from Access to SQL Server over the net

[Kingkumar]

Hi ,
I need to migrate some data from a client access database to my sqlserver database over the net. I am not sure how to do it because what is required is
1. The client should run sql statements in his database and the data should be exported to our database on sql server in a particular table.

I am not sure in access how/ whether this can be done???

If not then can it be done on sql server that it communicates with the access database and gets the required data over the net and fills the required tables with it ????
If yes can you guys help me with that.
Thanks.

--King

 

[Dimandja]

You can always Export from Access to a CSV file, FTP the CSV file to your machine, then Import into SQL with DTS.

__________________________________________
Try forum1391 for lively discussions

 

[Kingkumar]

Hi Dimandja,
Is there a way to do with this minimum human interaction.
Or IS THERE A WAY TO DO IT VIA SQL (OSQL)
Thanks
--Nripjeet Reen