ADO Transfer Spreadsheet to Access Table

[goss]

Hi all,

Using Excel 2010.

Trying to transfer the contents of a worksheet to a table in Access. I receive this error

The Microsoft Access database engine cannot find the input table or query 'tmp$'

The sheet definietely exists and is named "tmp"
Any other idea what the problem might be?

thx
w

Please Login or Register  to view this content.

[millz]

you can't execute SQL statements on Excel tables.
look up DoCmd.TransferSpreadsheet in the help (in Access)

[goss]

Thanks millz

I was able to get it working

Please Login or Register  to view this content.

Where [tmp$] is the name of the worksheet.
The headers on each column much match the field names in the table exactly.