ACCESS 2003

[tol514]

How can I import an xls and refresh a table in ACCESS via the macro object?

Tom Walsh, HRIS Analyst
Capital Health System
ADP HR&Payroll wi RSmith

 

[SkipVought]

Hi,

I'm sure there's a DoCmd to perform an import given an IMPORT SPEC.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PHV]

You may consider the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[tol514]

I wasn't trained in VB for ACCESS. I don't even know how to start. (?)

Tom Walsh, HRIS Analyst
Capital Health System
ADP HR&Payroll wi RSmith