Export of the named range from Excel into Access table 1

[vladk]

Hi,

I am trying to export the named range from Excel 2003 workbook into Access table. I receive the following error:
"Syntax error in INSERT INTO statement"

The code:

strSQL = "INSERT INTO Final_Table_Updated * FROM [INPUT_RANGE] IN " & "'" & ThisWorkbook.FullName & "'"

objRS.Open strSQL, mobjConnection

The connection is fine.

Thank you!

 

[SkipVought]

Hi,

Maybe Select * From...

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[vladk]

Hi Skip!

Thank you. I endeed needed the "SELECT"
I rewrote the statement:
strSQL = "INSERT INTO Final_Table_Updated SELECT * FROM [INPUT_RANGE] IN " & "'" & ThisWorkbook.FullName & "' 'Excel 2003;'"

And now receive this error:

Could not find installable ISAM.

How to fight this one?

Thank you

vladk

 

[vladk]

Solved it by replacing 2003 with 8.0

Thank you!