I'm pretty sure I need to use an ADO connection (which I've gotten to work) but I can't figure out how to add the data to the worksheet.<BR><BR>Any help would be GREATLY appriciated. ••• Quote ...

How to Import an Excel Spreadsheet Into Access With a Macro. If you ever wanted to click a magic button and make complex business tasks happen automatically, macros can make that wish come true.

I need to be able to get a date value stored in an Excel spreadsheet (say, C Temp\file.xls) in cell B28, and put that value into a variable to then use it in a VBA module in MS Access. <BR><BR>I ...