using Excel workbook as a datasource for ado connection object execute

[krankyboy]

Hi,

I want to import data from an excel workbook using a connection object based on my Access DB.

What is the syntax? I do currently with a text file no problem.

my code is something like:

connectionObject.Execute "Insert into mytable (fieldnames from
excel sheet
Datasource ????? HDR =yes ?????

Anyway you get the picture.

Any help will be appreciated.

Thanks,

A