Thinking outside of the box here. Setup a connection string that you can put the file&path they pick via a file picker and use ADO to pull the data. That accepts the various tabs or workbooks, which you can query.
On Fri, Apr 26, 2013 at 9: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/cajidmykizsic6lbce62ap673v_tyx+os3e-re_q9ya7ztpc...@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.
