Using Excel Data using Dao

[amitabh]

I am having trouble accessing the data from a excel worksheet. I am also confused regarding the "workbook "and "worksheet" terms. Can someone also send me the code to do it through DAO.

Thanks

[Edited by amitabh on 08-08-2000 at 08:59 PM]

[ttingen]

Worksheet is a single spreadsheet.

Workbook is a collection of worksheets. You know when you first open excel and the workbook loads with sheet1, sheet2, and sheet3.

Sheet1, etc., are worksheets while the file itself is the workbook.