A couple of questions: How many rows in this data?
I assume you are iterating through the sheets collection, but have you tried recording a macro that does a selection of the data, then copy to the clipboard, so you can paste into a text file? Have you tried iterating through the rows and columns collections of the activeworksheet? JH -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sytze de Boer Sent: Thursday, April 17, 2008 12:13 AM To: [email protected] Subject: VFP(9) Excel importing Hi Folk I need desperate help I'm trying to import data from a spreadsheet which has multiple sheets All is well except it refuses to import data stored in any column from J onward My command is a simple Append From (ximport) Type Xl8 Sheet "FTENTS" I've also tried IMPORT from (ximport) TYPE xls SHEET "FTENTS" and it does exactly the same thing i.e all the column details are in my table except from Column J onwards What gives -- Regards Sytze de Boer Kiss Systems Ph: 64-7-8391670 Mob:021 937611 http://kiss.systems.googlepages.com --- 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://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]@shelbynet.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.
