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:[email protected]] On Behalf Of Charlie-gm Sent: Thursday, June 22, 2017 9:16 PM To: [email protected] 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:[email protected]] 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] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/mwhpr10mb17742a503ab4806b01c26d77d2...@mwhpr10mb1774.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
