Access Data Import issue when Excel file is close

nadeemzaki@gmail.com

Guest

Posts: n/a

19th Jun 2007

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

« Export Wizard to csv | MS Access to Excel Code Review »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Import Access data to text file rather than Excel	Daniel Bonallack	Microsoft Excel Programming	3	5th May 2009 11:51 PM
import excel file to access but only new data	Daniel M	Microsoft Excel Programming	1	6th Dec 2007 11:44 AM
import data from close excel file	ceronnis	Microsoft Excel Programming	1	1st Dec 2005 09:28 PM
Import append issue (Excel to Access table); data transposition	=?Utf-8?B?c3RheWxvcjc0Xw==?=	Microsoft Access External Data	1	18th Oct 2004 10:14 PM
Import Excel to Access back-end data file	Denise	Microsoft Access External Data	1	10th May 2004 07:31 PM