Re: Copying access objects using .net
- From: Bob <Bob@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 22 Jul 2005 05:27:02 -0700
Val, thank you for your response. Although I can create a table in this
manner, it appears that I cannot create a query. Am I correct?
--
Thanks, Bob
"Val Mazur (MVP)" wrote:
> Hi,
>
> You need to use ADOX library to do this. ADO and ADO.NET manipulate data and
> could execute DDL statements, like CREATE TABLE etc, but they do not
> transfer objects from one db to another one as is. If you would like to
> transfer table using ADO.NET, then you need to create the table and all the
> indexes first using CREATE TABLE statement and then copy data.
> --
> Val Mazur
> Microsoft MVP
>
> http://xport.mvps.org
>
>
>
> "Bob" <Bob@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:83A9CA0C-AE90-4012-9885-DFD067B76CBB@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
> > (primarily queries but some tables) from another database into the
> > database
> > where the import action is selected---EXCEPT that I'd like to do this
> > externally with a VB.net program.
> >
> > --
> > Thanks, Bob
>
>
>
.
- Follow-Ups:
- Re: Copying access objects using .net
- From: Val Mazur \(MVP\)
- Re: Copying access objects using .net
- References:
- Copying access objects using .net
- From: Bob
- Re: Copying access objects using .net
- From: Val Mazur \(MVP\)
- Copying access objects using .net
- Prev by Date: Re: CommitTrans of object _Connection failed
- Next by Date: RE: Oracle Computed column datatype
- Previous by thread: Re: Copying access objects using .net
- Next by thread: Re: Copying access objects using .net
- Index(es):
Relevant Pages
|
|
