COPY all data from access table

10-21-2004, 01: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, 01:44 AM
Another Access table? With the same format? Then Copy, Paste and Rename I guess...

10-21-2004, 01: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??

10-21-2004, 05:01 AM
You mean like this?
SELECT Table1.*
FROM Table1

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum