Actually memofields are quite possible. Been a long time, but you just need to set the memowidth and then read off line by line via a scan, or do while
Did a lot of mailing list mergers for ziff davis institute way back when and the technique I've been describing works flawlessly. I'd probably need glasses now to see all the start and stopping points of a substr() now though as my eyesight isn't so good anymore <grin> -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Dave Crozier Sent: Friday, April 26, 2013 10:21 AM To: ProFox Email List Subject: RE: Excel Data Import into VFP w/Multiple Pages Kurt, Oh, and don't forget that importing memo fields is a big No-No without automation being used! Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Kurt Wendt Sent: 26 April 2013 16:11 To: [email protected] Subject: RE: Excel Data Import into VFP w/Multiple Pages Thanks Dave - I just passed on to the others here all the input you folks gave me - along with the Caveat you listed below - and I will let them mull it all over - as I am already buried with the Biggest project we have going here! And - I am for the most part up to this point - going it alone on that project... -K- -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Dave Crozier Sent: Friday, April 26, 2013 11:04 AM To: [email protected] Subject: RE: Excel Data Import into VFP w/Multiple Pages Kurt, The "sheet" option doesn't seem to work correctly on 2007 and above and If I remember correctly there is also a row limit on the number of rows that you can import into Excel, which is why I resorted to Automation which also allows you to format the data correctly. Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Kurt Wendt Sent: 26 April 2013 15:41 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.
