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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete Table data

Status
Not open for further replies.
AccessVB

AccessVB

MIS
Jun 23, 2002
82
0
0
US
Hi all,

Is there a way to easily copy all tables from an access db, without copying over the data? Or is there an easy way to delete data from all tables in an access db? Any help will be much appreciated.

Thanks,

RT.
 
Sort by date Sort by votes
If you create a blank database and choose import, you will find under Options "Definition Only" and "Definition and Data".
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

raywood1
  • Locked
  • Question
Reducing a Massive Linked Table
Replies
4
Views
111
dhookom
dhookom
MrStohler
  • Locked
  • Question
Beginner Q: How to separate data from Excel into related tables and maintain relationship? 1
Replies
5
Views
111
SkipVought
S
Anthony343242
  • Locked
  • Question
MS ACCESS UNION ALL with Attachment data type 1
2
Replies
29
Views
365
Anthony343242
Anthony343242
03Explorer
  • Locked
  • Question
Refreshing a linked table (housed on MS SQL Server) now breaks
Replies
3
Views
91
dhookom
dhookom
JayRo71
  • Locked
  • Question
Importing only unique records from excel tables 1
Replies
10
Views
174
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top