Export Linked Tables to make a self-contained mde

[Hfnet]

I have a database with linked tables to SQL server, Oracle and an mdb.

What I want to do is create a stand-alone presentation mde with sample data in one file.

How can I export all of the tables and column headers into an mdb so I can build a self-contained demo?

Thanks

Ask not what you can do for your boss, ask how much it's worth.

 

[PHV]

Have a look at Make table query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Hfnet]

Is there a simple way of doing a loop query to find each table name and export all tables like that? I have 250-odd tables to export!

Ask not what you can do for your boss, ask how much it's worth.

 

[JerryKlmns]

Dim tbl as TableDef

For Each tbl In CurrentDB.Tables
If tbl.Connect <> "" Then MsgBox tbl.Name
Next tbl

----------------------------
Tools-->References select Microsoft DAO 3.6 Object Library

 

[Hfnet]

Thanks, if only I hadn't done it all by now!! I'll know for next time...

Ask not what you can do for your boss, ask how much it's worth.