New Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I create a new table from an old one without any data in in (blank)
 
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
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Create New Table/Column 1
Replacing a Table with a Table from another database - reference issues 1
old Table Normalised. Extracted data linked to old in a one to man 2
Creating new Access 2007 database and importing the old data 1
Updating tables when you input new data 0
history of prices table 3
Same record/Primary key in multiple tables 0

Back
Top