Convert from SQL server to access

[pankajdaga]

Hi everyone,

I know most people are going from SQL server to MS Access. However, for my particular need I need to convert an SQL Server database to MS Access. I, however, only need to import the tables with all the constraints.

Is there any script or some simple way to do this? Any help would be greatly appreciated.

Thanks.

Sincerely,
Pankaj

 

[fuadhamidov]

hi
DTS ( Data Transformation Service ) may help you. try to find any information about DTS. i don't have any technical knowledge about DTS.