Importing from Access to Excel

  • Thread starter Thread starter Debby
  • Start date Start date
D

Debby

How do you import either a delimited text file or an
Access table to Excel when the source file is over 65,000
lines (my maximum with Excel 2002). I would like to be
able to import the text file to muliple worksheets on
Excel. Thanks
 
Since an Excel worksheet has 65,536 rows (period) your best bet may be to
break your source file up into several, each have no more than that.
 
Back
Top