I have excel workbooks in a folder. I would like to read them into an Access database. I have 15 columns in the excel workbook, I created the same number of columns in Access.

All I want to do is to read in the value. I tried the transferspreadsheet command and its not working.

What is the easy way to read the data into Access. I want to do this programatically.

Thanks in advance,

Reggie