Export sql server to access

[hana]

hi there,did anyone know how to export the whole database sql server to access in vb.net source code,plz help me..the dateline is coming up...

 

[Musab]

Hi Hana,

What version of SQL , Access are you using ?

Try this by Mohammed
Export data from SQL Server to MS Access : The CodeGain

and use ADO.NET to run the script from vb.net

-Musab

 

[hana]

i'm use sql server 2005..actually i want to export the whole database sql server to format .mdb no need to insert table one by one..and in vb.net source code..

 

[hana]

i'm using sql server 2005 and access 2007..actually i want to export the whole database sql server to format .mdb no need to insert table one by one,just save package using DTS..and in vb.net source code....

 

[MattP]

Downsizing from SQLExpress to Access