Importing from Access to Excel

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
 
J

Jim Rech

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import delimited text file into mulitple excel sheets 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access Subscript out of range when importing into access 2010 from excel 0
Importing Text Files Into Access 1
Text File Importing 2
Import External Data 1
Where is the Data Import Excel button in Excel 2007 6
Tab delimited text file import on double click 2

Top