EXCEL FILE IMPORT ISSUE

[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!

 

[Ken Snell \(MVP\)]

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

 

[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!

 

[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.

 

[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?

 

[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$