Don't know about that but like I said earlier I do this with automation pretty often. Typically I'll be adding data to a temporary table or cursor and then using the resulting thing to add in to its final destination. If you go this route, there are a few gotchas. You need to check for null values in the Excel cells. You can use the text cell property if the cell contains less than 1024 characters; otherwise you have to use the value property or your data will get truncated. OTOH if you have numbers stored as text, you have to use the text property or Excel will make assumptions for you about the cell contents.
Andy Davies wrote: > Richard Kaye said "Maybe there are some odd control characters in the data > you are trying to grab?" > > yes, that seems to be it - chr(0)'s (I'd just found 'em when I read your > reply <g>) > > I managed to do it by reading it into an ado cursoradapter in vfp - anyone > know how to make an Excel ca updateable? > > Andrew Davies MBCS CITP > - AndyD 8-)# > -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 For the fastest response time, please send your support queries to: Technical Support - [EMAIL PROTECTED] Australian Support - [EMAIL PROTECTED] Internet Support - [EMAIL PROTECTED] All Other Requests - [EMAIL PROTECTED] --------------------------------------------------------- This message has been checked for viruses before sending. --------------------------------------------------------- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** 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.
