Import multiple tables while selecting location

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

Guest

I am trying to import 3 tables from one Db using a macro allowing the user to
choose location. I only want the user to have to select location once and it
will import all 3 tables.
 
Well, you can't do it with macros because you have to hard-code the path
into the macro. However, you can covert your macro into VB code (use the
Save As) and replace the path in each of the commands to a variable, then
input that variable once.

For an idea of how to use the Open/Save dialog box to do the choosing, look
here:http://www.mvps.org/access/api/api0001.htm

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Same problem - I understand converting to VB Code - but am barely familiar
with the code itself.....how would you write the variable in??

If I'm going to a particular location that includes 50 or more files - but I
only want the files that include a certain # within the name..... how do I
write that code?

EX: Files SHWUD19a, SHWUD19b, SHWUD9c, SHWUD29a, SHWUD29b, SHWUD29c

I only want to import those files with "29" included in the name which would
be the last three above.

Thanks in advance for your help.
 
Back
Top