excel worksheet

[Frank Murren]

i have created a linked table to an excel spreadsheet.
i have now used up the maximum number of 65000+ entries in the worksheet and
need to open a second workshhet to continue the data capture.
my problem is that i need the linked table to be able to read both
worksheets at the same time
can anyone advise ?
thanks
frank

 

[Joe Fallon]

Stop using Excel?

Use Excel for data collection and write a daily import routine and run the
reports in Access.