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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible to import a specific sheets data from excel into access? 1
Using TransferSpreadsheet to import from Excel to Access with variable file names 1
Excel Data Transfer Issue (strange situation) 1
import EXCEL hyperlink into ACCESS 2007 0
import spreadsheet error on column headers 0
Import Excel 2010 table into Access 2010 - not listed as range 0
Import Excel data - File not open 11
Excel spreadsheet import problem 0

Top