Page 1 of 1

Maximum size Excel file

PostPosted: Fri Dec 18, 2015 3:26 pm
by DaveJ
Can anyone tell me what the maximum size Excel file Neobook can open?
I have an Excel file which is huge (198MB) and contains just under 5 million cells. Neobook understandably complains and says that it cannot open the table but is this a Neobook limitation or a system variable limit?

Ideally I would like to convert it to a true database but I get a new file every week.

Any suggestions would be great.

Thanks
Dave J

Re: Maximum size Excel file

PostPosted: Fri Dec 18, 2015 6:17 pm
by Neosoft Support
Since your Excel file is so large you probably need to use a 'LIMIT' type query so that DBPro doesn't try to read the whole thing into memory. You can use the dbpExecSQL action to open a large table/worksheet instead of dbpOpenTable. This will allow you to limit the number of records returned. For example, the following will display just the first 50 records from the Contacts table:

dbpExecSQL "AddrBook" "SELECT TOP 50 * FROM Contacts" ""
dbpShowGrid "AddrBook" "Contacts" "Rectangle1"

You could use other types SQL queries to limit the number of records displayed at one time. The trick is to avoid trying to display all 5 million cells at the same time.

Re: Maximum size Excel file

PostPosted: Sun Dec 20, 2015 10:04 am
by DaveJ
Many thanks to Dave Riley who noticed that Excel requires [] around worksheet names when using SQL statements.
So below is an example that works.
Code: Select all
dbpExecSQL "Test" "SELECT TOP 50 * FROM [#91]Sheet1$[#93]" ""