Excel tables as a Recordset?
Posted on 2003-02-19
I have like 100 tables exported from Access into Excel (one on each sheet) where the first row has the field names and the preceding rows have the data. Is there a way to access these tables the same way you can access a recordset. I'm using Visual Basic 6 with DAO (NOT ADO)
(This is what I want to be able to do)
LastName = MyExcelTable![lastname]