Fred - thanks SO MUCH For that Heads up. I should have quickly looked at the Import command. Maybe the Sheets thing is newer to VFP 9. But, I will Definitely consider this option.
And - since its this Other Guy here who will do the project - the concept of Automation is probably foreign to him (kinda like proper English is Foreign to him) - and the Automation technique may be way over his head... :-) -K- -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Fred Taylor Sent: Friday, April 26, 2013 10:51 AM To: [email protected] Subject: Re: Excel Data Import into VFP w/Multiple Pages The IMPORT command does have a SHEET option for XL5 nad XL8 TYPEs though I've never used them. I usually use automation to have more control of what's going on. Fred On Fri, Apr 26, 2013 at 7:40 AM, Kurt Wendt <[email protected]> wrote: > Hey folks - I think this should be a quick question - pretty much a Yes or > No answer. > > > > 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. > > > > Am I right? Is the Only option to use something like Office Automation? > > > > TIA, > > -K- > > > > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [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/D2903A2441C74E05AA9022BD324442F8@Programming2 ** 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.
