Importing FoxPro Tables via Macro (1 Viewer)

[olan]

I have imported number of FoxPro tbls. I want a macro to run every time the user opens the Access program which will import these files again to refresh the data. However using the TransferDatabase even with my ODBC string it's not working. Any ideas???