Hey Dave - thanks for the input. I suspect when you wrote "import into separate tabs" - that you really meant "import FROM separate tabs". And, yeah - I kinda figured that might be the case. Although - Fred seems to disagree - and mentioned how it could possibly be done.
-K- -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Dave Crozier Sent: Friday, April 26, 2013 10:51 AM To: [email protected] Subject: RE: Excel Data Import into VFP w/Multiple Pages You can't automatically import into separate tabs, unless you use Automation, in which case it is quite easy. Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Virgil Bierschwale Sent: 26 April 2013 15:45 To: 'ProFox Email List' Subject: RE: Excel Data Import into VFP w/Multiple Pages I'm rusty, but I always saved each page as a csv if memory serves me correct and then did a import into sdf >From there I wrote a routine that would read each line, get the >substring I wanted and plug it into the table -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Kurt Wendt Sent: Friday, April 26, 2013 9:41 AM To: [email protected] Subject: Excel Data Import into VFP w/Multiple Pages 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/D6145E7BE59E4860A1AA8C399934EE2D@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.
