On Thu, Mar 20, 2008 at 3:34 PM, NickC <[EMAIL PROTECTED]> wrote: > Almost there! > > It transpires that writing with ADO is nearly impossible so I have almost > found another way... > > 1). Use ADO to read all data from one worksheet > 2). Use a CursorAdapter to convert the ADO Record Set into a VFP cursor. > 3). Use the VFP 'EXPORT TO x TYPE XL5' to create the new spreadsheet. > > Only minor problem is that CursorAdapter resolves all the text fields in > the > ADO record set to Memo fields, unfortunately VFPs Export TO and Copy TO > commands ignore memo fields, bugger! Well I have got a test working by > copying the cursor to a table and then converting all the memo fields to > text. > > Remaining questions if anyone has any suggestions: > 1). Is there any way to get CursorAdapter to import as text fields rather > than memo? > 2). Is there any easy way of converting all memo fields in a cursor to > text? >
-------------------------------------------------------- Access is probably the best tool to do this with. If that can't be done on the server, why not put an MDAC on the server and use the excel file as a data source for a query? Then your data will be returned to you in VFp easier to use? -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://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.