Refresh Imported Table with VBA

[Brad]

Is there a way to refresh an imported table (from SQL-Server via ODBC) with
VBA code?

I did a “Save Import Steps†so I have a “Saved Importâ€.

Is there a way to run this “Saved Import†with VBA commands?

Thanks,

Brad

 

[Piet Linden]

Is there a way to refresh an imported table (from SQL-Server via ODBC) with
VBA code?

I did a “Save Import Steps” so I have a “Saved Import”.

Is there a way to run this “Saved Import” with VBA commands?

Thanks,

Brad

you should be able to use the import spec with the TransferDatabase
command.