Access 2000 to Excel 2000 Row Limitation

D

DSCAVOTTO

I have an Access 2000 data base file that I want to be able to export to
Excel 2000. The Access file has more than 70,000 lines of data, which exceeds
the file size Excel allows. How do I break up the Access file to export it to
two separate Excel files or two different worksheets in one file?

The other issue involved is I want to be able to keep all similar
transactions together (i.e. data will be sorted by "Source") in one tab or
file. There can be more than one line item with the same Source transaction
code.

Thanks for your help.
 

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

Autonumber field in Excel that behaves the same as Access 0
Access 2003 and excel 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Excel file linked to external source 0
Access-->XML-->Excel: Size Limitations? 0
nk into onenote 2016 paragraph from excel 2016 cell 0
Exporting to Excel 0
Export Many Unrelated Access (2000) Data Tables to Excel 6

Top