Re: vb.net code to copy queries and tables from 1 ms access db to anot

Bob

Connect to the DB you want to copy FROM with an OLEDBCONNECTION Object
then....
sql = "Insert INTO TABLE IN '" & path & "\data\Temp.mdb' Select * from
TABLE" where TABLE is your Table Name

cmd = New OleDbCommand(sql, cn)

cmd.ExecuteNonQuery()



Regards

Steve

"Bob" <Bob@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5A75BC9D-BC41-45DB-A929-0EB1CAF5AD04@xxxxxxxxxxxxxxxx
> How do I program vb.net to copy a query or table from one MS Access
> database
> to another?
>
> I'd like to accomplish what import does when it copies Access objects from
> another database into the database where the import action is occurring---
> EXCEPT that I'd like to do this externally with a VB.net program.
>
> --
> Thanks, Bob


.