I hear you about program breakage when XLS file columns are changed - and there was a HEATED Thread on this forum not too long ago - exactly related to this... -K-
-----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Virgil Bierschwale Sent: Friday, April 26, 2013 11:01 AM To: [email protected] Subject: RE: Excel Data Import into VFP w/Multiple Pages Understood. I used to automate it. Did a gig for the childrens hospital in boston a long time ago. For some reason they could not access the accounts payable history on the mainframe I used this technique to grab the data via obdc from the mainframe where they controlled the keys. All they had to do was push the button and then they could do all kinds of whatifs Problem with spreadsheets is anybody can change the columns and that will break a program like that -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Kurt Wendt Sent: Friday, April 26, 2013 9:58 AM To: [email protected] Subject: RE: Excel Data Import into VFP w/Multiple Pages Thanks for all the quick input folks! Virgil - I don't think the client would be too thrilled to have to open the Excel file - do an export - and THEN run some import within our system. But, I will keep this possibility in mind as an option - especially since it may be cheaper and easier to implement than doing Automation... -K- -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Virgil Bierschwale Sent: Friday, April 26, 2013 10:45 AM To: [email protected] 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/93D73C6A400B4216BF94CCF3A4C871D1@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.
