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.
 
You must log in or register to reply here.

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
import delimited text file into mulitple excel sheets 1
Multiple Delimiters 5
Data Import Question 4
Import Data, using a command line switch 5
Importing Text Files Into Access 1
Where is the Data Import Excel button in Excel 2007 6
Reformat Excel for Access import 1

Back
Top