Re: vb.net code to copy queries and tables from 1 ms access db to
- From: Bob <Bob@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 26 Jul 2005 02:34:02 -0700
Thanks Steve.
How would I copy a query from one Access database to another?
--
Thanks, Bob
"steve" wrote:
> 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
>
>
>
.
- References:
- Prev by Date: RE: updating data
- Next by Date: Presence and future of data access
- Previous by thread: Re: vb.net code to copy queries and tables from 1 ms access db to anot
- Next by thread: Microsoft ODBC SQL SErver Driver Timeout Expired
- Index(es):
Relevant Pages
|
|
