Source language: Translate to:

Maximum size Excel file

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

Maximum size Excel file

Postby DaveJ » Fri Dec 18, 2015 3:26 pm

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
DaveJ
 
Posts: 90
Joined: Tue Dec 30, 2008 11:06 am

Re: Maximum size Excel file

Postby Neosoft Support » Fri Dec 18, 2015 6:17 pm

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.
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5593
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Re: Maximum size Excel file

Postby DaveJ » Sun Dec 20, 2015 10:04 am

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]" ""
DaveJ
 
Posts: 90
Joined: Tue Dec 30, 2008 11:06 am


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 2 guests

cron