Copying Tables

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

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

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

Try This

Code:

---

SELECT * INTO newTable FROM oldTable

---