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

On Aug 21, 8:40*am, Brad <B...@discussions.microsoft.com> wrote:
> 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.