New Table

J

Jeff Boyce

Dennis

Easy to do ... but first, why? If you are constructing a table that is an
exact match (duplicate structure) in order to hold data from a different
source, or covering a different time period, or related to a different
category, stop now! Access is a relational database, and creating duplicate
(structured) tables to hold related data is ... a spreadsheet!

Now, to do it, after a caution like that, highlight the table in the
database's database window. Right click and Copy. Find some open space and
right click, then choose Paste. You'll be prompted to duplicate the table,
data and all, or just the structure.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

Jerry Whittle

SELECT * INTO Tables2
FROM Tables1
WHERE 1=2;

The above will just make the table and field. It won't include things like
indexes or primary keys.
 
D

Dennis

Thanks I need to send the completed table to another site who doesn't neew my
info just theirs. I was thinking about puttting another field to select and
sort out the other sites but then I may end up maintaining everyones db,
which I may end up doing anyway
 
Top