Access 2010 Saved Imports

[Tomfernandez1]

Hello,



Is there a way to use a command button to execute a Saved Import? I have a Saved Import that I execute using Access default options. A command button on the switch board would be nice.. Any information or direction would be much apprecated!!

On a related note - I have a Table called "2011" that gets updated via the Saved Import process. This process brings over a Table called 20111 which I have to rename 2011, by first deleting the already named 2011. Is there a code that can do this that can be run through a command button?

Tommy

[TheShabz]

look up TransferSpreadsheet in Access VBA. That's essentially what a saved import is.