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...
shuhana84
0
Light Poster
Recommended Answers
Jump to PostUmm why would you do that?
As far as i know Access doesn't support multiple insert.
Jump to Posthi,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...
All 8 Replies
finito
46
Nearly a Posting Virtuoso
Umm why would you do that?
As far as i know Access doesn't support multiple insert.
shuhana84
0
Light Poster
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...
kvprajapati
1,826
Posting Genius
Team Colleague
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...
Read this article - http://www.databasedesign-resource.com/import-and-export-in-sql-server.html
shuhana84
0
Light Poster
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
finito
46
Nearly a Posting Virtuoso
For Each
INSERT INTOThats the only available option to you.
shuhana84
0
Light Poster
Do you mean that,i need to select n insert table one by one??and ?there're no other ways???
finito
46
Nearly a Posting Virtuoso
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.
shuhana84
0
Light Poster
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...(^_^)
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.