Copying Tables

[Ovid]

How can I copy an individual table from one microsoft access database file to another?

[Altecjjf]

i think this is what you want but not sure:

1. Open a new database,name it, then save it
2. Use the "Get external Data" under "File"
3. You can use "Import" or "Link Tables"

I think this may help but not sure what you mean by "Copying Tables"

Jer

[Ovid]

That's exactly what I mean. However, I need code to do that for me. Any ideas?

[Negative0]

Try This

SELECT * INTO newTable FROM oldTable