Import button issue in the form

[Guest]

I am trying to automate system.
I have button 'Import Excel'.
Here is my code behind the button:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel4,
"tblImportData", "C:\Data.xls", True

When I click on Command button, i get this message error:

"Field 'Name' doesn't exist in destination table 'tblImportData' ."

But I do have a field name in this table.

Please tell me What is wrong with this code or tell me any other way to do it.

Thank you so much.

 

[Nikos Yannacopoulos]

Very likely the problem is that you are using an Access reserved keyword
(Name) as a table field name (the latter use of the word is indeed what
Name is, a property to an object!). This tends to create this kind of
problem, Access not being able to distinguish an object (field in this
case) from a property.

Try changing the field name to something else (both sides, access table
and spreadsheet) and try again.

HTH,
Nikos

 

[Guest]

I did change field name and I stil have same error.
I did even try to import from "File-Get External Data-Import", I unable
import the excel file.
??????????

 

[Guest]

I had extra space, now is working.

Thank you

I did change field name and I stil have same error.
I did even try to import from "File-Get External Data-Import", I unable
import the excel file.
??????????

 

[Nikos Yannacopoulos]

Glad you cracked it!