when accesing an Excel Workbook using ADO method the sheet names must
end wit a dollar sign like you are using in the code to get sheet
Sales$. I don't see two worksheets in the macro. Only the "Sales"
sheet.

To get data from multiple worksheets you need in the FROM section of
your SQL you need to add all the worksheet names. If you sheet names
are similar the LIKE may work. Not sure.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=167354

Microsoft Office Help