Regarding a macro using TransferDatabase

[Juggler]

I have created a Macro which loads a table using the TransferDatabase method and it works fine. But, when I run the Macro, a DBF file is grabbed and loaded into in Access table and then an append query loads the final table. What I want to know is, can I set it up so it prompts the user to select the source file, I need to load this file regularly and the file name changes.

[TonyES]

Convert your macro to VBA and then have a look at the InputBox function or the FileDialog object.

[Juggler]

Great, thanks for the help