Automating a SavedImport (1 Viewer)

[liddlem]

Hi Folks
I am using Acces 2007.
I have saved a number of imports and would like to run them in succession.

I created a macro which opens the savedImports dialogue box, but how do I get them to run without my intervention?

I presume that I would have to make the call from VBA, but dont know how to pass/parse the name of the savedimports in the code.

Thanks

 

[joh024]

Hi Folks
I am using Acces 2007.
I have saved a number of imports and would like to run them in succession.

I created a macro which opens the savedImports dialogue box, but how do I get them to run without my intervention?

I presume that I would have to make the call from VBA, but dont know how to pass/parse the name of the savedimports in the code.

Thanks

Are you just talking about using a scheduler to run the macro?

 

[liddlem]

Not really - I need to run the saved import at irregular times (on demand).
However, I have subsequently learned why I couldnt get it right.
The names of my saved imports were the same as some of my tables.
DUH !!!

Thanks