Access Data Import issue when Excel file is close

N

nadeemzaki

Hi All,

I am trying to use a built-in Access macro (TransferSpreadSheet) to
imports data from an excel file. This works fine when the actual
excel spreadsheet is open. It will not work if the spreadsheet is
closed.

I have also tried to do it via VB using DoCMD method, but the
samething.

Look like somehow that some under lying process ( some .dll, some
library etc) that "TransferSpreadSheet" macro use, is not working.

Any recommendation or Suggestion to resolve this issue

Thanks
 
Top