TransferSpreadsheet

[Tim Wright]

Using Access 97 I am working on a Database that imports using a macro about 60 Tables from different Excel Spreadsheet files. To do this I have to give the directory name for each file. In the event that these directory names change or move, is there a way to prestore a directory name in 1 spot rather then having to go through all the file names under Transferspreadsheet and individually changing them.

 

[Pat Hartman]

You can do this easily if you switch to VBA and use the TransferSpreadsheet Method instead of using macros. The simple but clunky way to do it is to use the Tools/Macros/convert macro to code feature to create a VBA procedure that executes the TransferSpreadsheet Method 60 times.

If you know how to code you can replace this with only a small amount of code that loops through a list of file names and executes the TransferSpreadsheet Method using variables rather than literals.

[This message has been edited by Pat Hartman (edited 10-03-2000).]