importing accounting data am limited to 16384 line - why?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to import stock data from an accounting system and although there
are more than 16000 lines, I am always limited to 16384 lines which is well
below the geberal sheet limitation of 64000 lines. Why is that; can I get
around the problem easily?
 
Just a guess - is the accounting system a little on the old side? I seem to
recall that one of the older Excel versions had row limit of 16,000+, so
maybe it's the accounting system's export that is the culprit, by limiting
the data it exports to 16384 rows
 
Thank you for your trouble; you're probably right. My colleague tells me he
has just managed to do it by using Foxpro (the program in which the accounts
package -Opera II is written), to export the data to Access and from there to
Excel.
 

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

Importing Large Text Files 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel text export limit - 1024 per line (not cell), workaround? 11
Why the arbitrary spreadsheet size limitations? 7
dowloading data of CSV file to excel file 2
Data Import Question 4
import XML data...Is there a size limit on the import? 0
xml import....Size limit?? Can the XML file be split?? 0

Back
Top