hi,i want to know how to export sql server 2005 database to access through vb.net coding..no need to select n insert table one by one,just save package...

access doesn't support multiple insert???really?so do you have any solution how to export the whole database sql server to access and of course save in format .mdb?actually i'm using sql server 2005 n access 2007..plz..help..all the source code i've found show need to select first from sql server then insert in access but only for one table..in my case it involved about 15 table and one of the table have about 30/40 fields...

thanks...i always use this DTS..i want it to be done in coding,because i must perform it in form to user..user just have to click button on form and done,sql server have been transfer n save to format .mdb

Do you mean that,i need to select n insert table one by one??and ?there're no other ways???

Do you mean that,i need to select n insert table one by one??and ?there're no other ways???

programatically I believe so. But then again I am not the all knowing maybe there is a hidden way that I don't know about. Maybe you can use SQL Managment Studio API to do what adatapost did. But then that give a dependency on SQL Managment.

programatically I believe so. But then again I am not the all knowing maybe there is a hidden way that I don't know about. Maybe you can use SQL Managment Studio API to do what adatapost did. But then that give a dependency on SQL Managment.

ok..thanks for your kindness and advice..i'll try my best...(^_^)

This question has already been answered. Start a new discussion instead.