I have a small database with a couple of tables. I am trying to set it up for distribution so I need to automate the export of the Table. I would like to be able to press a command key, and have the entire table copied to a floppy disk and then the existing records deleted. I can do it manually, but that leaves an awfully lot of room for error. The users are not specifically computer literate and I would rather not have to ask them to take the time to do this manually. Any suggestions?
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!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to Automate export of Access Table 2
- Thread starter PaulaJ
- Start date
-
2
- #2
You could use the TransferText method of the Docmd object to transfer your table to a comma delimited file on a floppy. Then you could write a little routine to load the data back up into the users table or you could just create a link to the textfile. Durkin
alandurkin@bigpond.com
alandurkin@bigpond.com
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question