On Fri, Apr 26, 2013 at 8:40 AM, Kurt Wendt <[email protected]> wrote: > This client of ours - they are getting Excel spreadsheets from a Factor. > And, they want to pull the Excel data into our systems to process it & run > reports. The main problem I see - is that the Spreadsheet has Multiple > Tabs/Pages - and so I'm assuming you can NOT to a Simple data Import into > VFP from Excel if this is the case.
I have used "APPEND FROM ... TYPE XL5 or XL8 SHEET cSheetName" for this purpose. Unfortunately, I had found that files saved with Excel 2007 as xls caused problems with "APPEND FROM ..." imports so I eventually switched to Office Automation. I tried using Excel ODBC connection for a while, but found that it was too sensitive to mis-formatted data. Automation is slow but robust. -- Dave Thayer Denver, CO _______________________________________________ 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/CAAo+qoXh+74ACYpAQJrmkuA=rdbhvxz6urkfibf8vudrm1_...@mail.gmail.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.
