Actually there's a VFPx project (https://github.com/ggreen86/XLXS-Workbook-Class) that can read and write native XLSX without Excel. Having said that, if you're using the XLS format than you will need Excel, as Charlie says.
--
rk
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Charlie-gm Sent: Thursday, June 22, 2017 9:16 PM To: profoxtech@leafe.com Subject: Re: Bulk Imports While Multi-User System is in Use
On 6/22/2017 3:40 PM, Paul H. Tarver wrote:
My first thought when I read this was that I would create temporary cursors (CREATE CURSOR) to import the data initially and then add the new records to
[snip] Agreed with temp cursors. It gives you incredible flexibility if you need it. No worries about table locks etc.
As another option, you could use Excel automation. But I would not recommend that if the import has a performance requirement (e.g. get it loaded within 30 sec). Another downside is the computer performing the data load would have to have Excel installed.
In both the above cases, you can do the record inserts one at a time, removing the worry about long "table locks", etc. And you could even give a progress bar as you do the inserts.
HTH, -Charlie
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Ken Dibble
[snip]
I've been given the task of importing data from a spreadsheet into my multi-user system. I have not done any testing on this but it is possible that the import process, run every week or every two weeks, will create thousands of records that will be "children" of a few hundred "parent" records. The system is in near constant use by somewhere around a half-dozen people, and much larger numbers use it occasionally. Some of the half-dozen intensive users are quite likely to be accessing the parent records at the time the bulk import process is creating the child records. I am concerned about creating massive access conflicts leading to race conditions, freezing of the system, and/or data corruption. Should I just block everybody from saving any data while the import
[snip]
[excessive quoting removed by server]