Excel is being used as a database. The initial problem with Append From is that on the first column (Id field) it adds a CHR(0) at the front of the field and chops off the last character.
Nick > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of John Weller > Sent: 14 March 2008 13:44 > To: [email protected] > Subject: RE: Getting at Excel data from VFP > > OK point taken. > > What does Excel do to the data? Is it dates for instance, if so could you > import them as text and parse the text? > > John Weller > 01380 723235 > 07976 393631 > > > > > > > Excel spreadsheet is edited by numerous people during the day, > > need prog to > > run on schedule every night. > > > > > > > [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] ** 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.
