vb 2005 SQLOLEDB to JETOLEDB

[KLin816]

Hi everyone,

i am new to this forum and also programming. My question is i am trying to open a notepad .txt file with sql queries then open and connect to a server with SQLOLEDB provider to get the data using those sql queries from the notepad then put all the extracted data into a MS Access table. Can anyone give me a hint on how to do that?

thank you very much.

K

 

[cjard]

Oh wow.. what a headache. Well, reading the text file isnt so hard.. just.. er.. read the text file, make a new SqlCOmmand and execute it

The SQL Server can put the data into access.. make a link to the access db then call INSERT INTO

Or you can do it dynamically.. see the post in this forum by InertiaM http://www.vbdotnetforums.com/showthread.php?t=25190&goto=newpost

 

[KLin816]

thanks for the help. i will do more research.

K