VBA to pull information into Access from Excel 1

[SkydivingSteve]

I've got users completing timesheets in Excel and I need to get this data into Access programatically. Could anybody point me towards some resources?

The user must use Excel for the timesheets and the format is not changeable so I must use code from within Access.

What I'm thinking of is 'click here to import timesheet'...

Thanks in advance!

Steve
"Call in an airstrike, with a poison kiss"

 

[CautionMP]

SkydivingSteve,
Will your Excel format support [tt]DoCmd.TransferSpreadsheet()[/tt]?

CMP

(GMT-07:00) Mountain Time (US & Canada)

 

[lars7]

Hi,
Is something like this what your looking for:


DoCmd.TransferSpreadsheet acImport, 8, "tblyourtable", "yourFilePathWay\YourExcelSheet.xls", True,