EXCEL FILE IMPORT ISSUE

A

Andy

I'm using the MACRO to import data (Excel file) into a table. It works fine
at
the past but found error message to "The Microsoft Jet database engine could
not find the object". Make sure the object exists and that you spell its name
and the path name correctly. (error 3011)"

I am sure I spell its name and the path name is correct, could you please
advise!
 
K

Ken Snell \(MVP\)

You'll need to give us more information.... what is the path and filename
that you're using, etc.
 
A

Andy

Hi Ken,

I'm using A2002, Window XP, the file name as below.
C:\DWS Migration Data\Sk Dovechem\Monthly delivery 2006.xls

But I tried another excel file is okay for import as below,
C:\DWS Migration Data\Sk Dovechem\Monthly delivery 2005.xls

Appreciate for your expert comments. Thanks!
 
K

Ken Snell \(MVP\)

Do you have password protection on the "2006" EXCEL file? Is the file closed
when you try to do the import?

Post the macro's actions and arguments that you're actually using. This one
is a bit of a puzzler.
 
A

Andy

No password protection and file is closed for import. Below Macro's actions
for your reference.

Transfer Type : Import
Spreadsheet Type : Microsoft Excel 8-10
Table Name : CUST QTY IMPORT
File Name : C:\DWS Migration Data\Sk Dovechem\Monthly delivery 2006.xls
Has Field Names : Yes
Range : none

BTW, the excel file has 3 worksheets, I tried to import the 1st worksheet is
okay but fail to import for 2nd & 3rd worksheets, format & field name are
same for these worksheets, what's the problem?
 
J

John Nurick

PMFJI,

If you want to import from specific worksheets, try adding a $ to the
worksheet name in the Range argument of the macro, e.g.

Sheet1$
 

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

Top