Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copy contents of the whole table

Status
Not open for further replies.
reta

reta

Technical User
Dec 23, 2004
51
AU
Does anyone know how i would be able to copy a whole table in ms access without, inserting each record from one table into the new table.
In other words am i able to copy the contents of one table into another.
Thanks
Reta
 
Sort by date Sort by votes
Have a look in the help for append queries. They will do just what you need.

Ben

----------------------------------------------
Ben O'Hara "Where are all the stupid people from...
...And how'd they get so dumb?"
rockband.gif
NoFX-The Decline
----------------------------------------------
Want to get great answers to your Tek-Tips questions? Have a look at F
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
1K
Andrzejek
Andrzejek
M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
4K
SoftwareRT
SoftwareRT
Drago1920
  • Locked
  • Question
Finding the lowest date
Replies
2
Views
505
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Transfer data from external table to identical local table - urgent please
2
Replies
27
Views
1K
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Vba adding record to table when field is integer
Replies
8
Views
655
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top