Need to import a table & Query from one mdb to other
-
Hi all, I have to import a table & a Query from c:\Programfile\asd\MyProject\test.mdb to c:\document&settings\ applicationdata\test.mdb. I have created & established the Connection string & all. the only thing i am not getting is Query needed to pass... Please help.. Ashish
-
Hi all, I have to import a table & a Query from c:\Programfile\asd\MyProject\test.mdb to c:\document&settings\ applicationdata\test.mdb. I have created & established the Connection string & all. the only thing i am not getting is Query needed to pass... Please help.. Ashish
Open the destination database using Access, then click File-->Get External Data-->Import and select the tables/queries you want. This is the simplest way!!
I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!
-
Open the destination database using Access, then click File-->Get External Data-->Import and select the tables/queries you want. This is the simplest way!!
I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!
-
Thanx but i need it to implement in my C# code... So i need a query to execute this step :)
If you are doing it in the client (c#) then you need to get the data from one database, hold in in a datatable while you establish a connection to the target database and use the second connection to write the records over that connection. You can of course open 2 connections before starting the process!
Never underestimate the power of human stupidity RAH