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/[email protected] ** 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.
