Re: Copying access objects using .net

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


.

Relevant Pages

  • Re: Design Question - formatted this time - sorry
    ... I'm designing a small stand-alone planning tool whose sole purpose is ... to provide an intuitive way to manipulate data in two tables of a ... JDBC to connect to the database directly. ... GuardedObject only checks the permissions when you try to "run" the ...
    (comp.lang.java.programmer)
  • Re: help with replace function
    ... by the way i found the built in function for replace within the table ... Access is designed to manipulate data within Access tables, ... It wasn't written to let you open any arbitrary file, ... Are they serving the role of database tables? ...
    (microsoft.public.access.modulesdaovba)
  • Design Question: Access Permissions and Client Synchronisation via a DB
    ... I'm designing a small stand-alone planning tool whose sole purpose is to ... provide an intuitive way to manipulate data in two tables of a Database ... JDBC to connect to the database directly. ... who has been using which data since when) and an oracle sequence is ...
    (comp.lang.java.programmer)
  • Re: Run VB.net application in Access 97
    ... manipulate data in the access 97 database from the outside the ... Michel Posseth ... Is it possible to write a .net Add-in for that?? ...
    (microsoft.public.dotnet.languages.vb)