COPY all data from access table

matt99999
10-21-2004, 02:41 AM
Hi, does anyone know of a method of copying the whole contents of an access table into another table, rather than reading and writing individual records??

thanks in advance for any pointers!

Demon Cleaner
10-21-2004, 02:44 AM
Another Access table? With the same format? Then Copy, Paste and Rename I guess...

matt99999
10-21-2004, 02:47 AM
what I meant to include, is that is being done by a vb program, normally to access the tables I am using ADODB and creating SQL statements to select a record then insert a record, but I just want to be able to "SELECT" ALL records and "INSERT" all records but it appears INSERT with SQL is record at a time. So is there a way in SQL I can do this or another method??

Timbo
10-21-2004, 06:01 AM
You mean like this?
INSERT INTO Table2
SELECT Table1.*
FROM Table1
:)

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum