Hi,
Let's say I have a database called testTemplate.mdb in c:\ which is a template-like database where i import data to.
Is there a way for me to copy the testtemplate.mdb and past it to my desktop with file name test.mdb.
I don't want to copy any data from the database, just the table's + queries
I would like this to be done via a macro... In order for me to execute other macro's to copy data from excel to that test.mdb file on desktop.
Last edited by pr4t3ek; 11-13-2008 at 11:03 PM.
--
Regards
PD
----- Don't Forget -----
1. Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
2. Thank those who have helped you by Clicking the scales above each post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Hi
something like this might work. It makes a copy of the database then deletes any table relationships (otherwise table records can't be deleted) and then deletes table records.
Please Login or Register to view this content.
excellent!
for some reason i was getting an error with ".Execute mySQL"
I commented it out and the macro work's so i guess that's fine.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks