Board index » delphi » Copy a table from a .MDB to other .MDB

sna

Delphi Developer
Mon, 22 Dec 2003 02:10:59 GMT

Copy a table from a .MDB to other .MDB

does anyone know how to copy one table from a .MDB to other different .MDB?

Thanks.

 
stephen.whi..

Delphi Developer
Mon, 22 Dec 2003 16:31:00 GMT

Re:Copy a table from a .MDB to other .MDB


On Wed, 4 Jul 2001 20:10:59 +0200, "sna" <SPAM...@menta.netQUITAR>
wrote:

Quote
>does anyone know how to copy one table from a .MDB to other different .MDB?

>Thanks.

Just cut-n-paste.

In Access, select the table you want to copy.  Right click, and
select "Copy".

Close that .MDB, and open the one you want to add the copy
to.  Right click, and select Paste.  It'll ask if you want to paste
just the structure, or the structure and the data.  (I think there
may be another choice there, too, but I can't think of what it
is.  Append data, maybe?)  

Just fill out that box and hit OK, and it's done.

--
Stephen Whitis
Email replies should go to...
scw120198 (at) whitis.com

The address in the header is not valid.

sna

Delphi Developer
Tue, 23 Dec 2003 00:54:53 GMT

Re:Copy a table from a .MDB to other .MDB


Sorry, maybe i wasn't clear. I need to do it programming delphi.

Quote
> does anyone know how to copy one table from a .MDB to other different
.MDB?

Dan Brenna

Delphi Developer
Tue, 23 Dec 2003 11:43:38 GMT

Re:Copy a table from a .MDB to other .MDB


On Thu, 5 Jul 2001 18:54:53 +0200, "sna" <SPAM...@menta.netQUITAR>
wrote:

Quote
>Sorry, maybe i wasn't clear. I need to do it programming delphi.

>> does anyone know how to copy one table from a .MDB to other different
>.MDB?

Here is an SQL method from M. H. Avegaart just a few days ago:

SELECT *  INTO Table1 IN "other.mdb"
FROM Table1

Also, look up Heterogenous joins in the LocalSQL help. That shows how
to work with two different DBs at the same time.

HTH,
Dan
--
Dan Brennand
CMDC systems, inc.
Configuration Management and Document Control:
visit us at www.cmdcsystems.com
[SPAM block: change at to @ in my e-mail address]

Other Threads

1. Copy data into another table? MDB->DB4

2. Access 2000 .mdb tables

3. Export and import tables from MDB-Files to Ecxelsheets

4. Add a new Table to a MDB Database

5. Create of Tables SQLServer -> Access.mdb

6. Tables in an .mdb file

7. Rename the table in mdb file using SQL statement

8. How can i create a new table in a mdb with ADO

9. Query using tables in different .mdb files

10. ODBC -- problem creating .mdb table