Tom, See the attached example of a CSV file. Note the double quotes inserted by Excel 2000 automatically for certain text values. I always SET QUOTES=" before LOAD...AS CSV... to be on the safe side.
Not sure though whether it helps in your case. Stan ----- Original Message ----- From: "Tom Grimshaw" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 9:28 AM Subject: Re: Import Failures and other brick walls > Thanks Stan, > > At 08:57 19/03/02 -0500, you wrote: > >Suggestions inserted below. > >Stan Loo > >-- SET QUOTES=" (Excel's default is double quotes. Open a saved CSV file > >with Notepad and you will see this.) > > Not in my installation. If I save a file as CSV it has > no quotes as the default, could find nothing in the _really_ > helpful MS Excel help. > > >-- (Looks like that one or more text values contain an apostrophe or a > >single quote. Do a search. SET QUOTES=" just before LOAD .... should > >correct this and perhaps > >the error problems too. Then include SET QUOTES=' after LOAD ...... or > >where needed.) > > I omitted to mention that I am testing this with a very vanilla > 6 line file that was hand crafted to contain no anomalies (like > embedded quotes). > > >2. As an aside, do you know how to save an Excel > >spreadsheet into a CSV with double quotes round the text? > > > >-- See above. > > > > > >3. SET VAR vErrorTest = .SQLCODE following the --** does > >not retrieve an other than 0 error, probably due to the > >prior command not being an SQL command. What do you > >use here? > > Warmest regards, > > > Tom Grimshaw > coy: Just For You Software > tel: 612 9552 3311 > fax: 612 9566 2164 > mobile: 0414 675 903 > > post: PO Box 470 Glebe NSW 2037 Australia > street: 3/66 Wentworth Park Rd Glebe NSW 2037 > > email: [EMAIL PROTECTED] > web: www.just4usoftware.com.au > > This email and any files transmitted with it are confidential to the > intended recipient and may be privileged. If you have received this email > inadvertently or you are not the intended recipient, you may not > disseminate, distribute, copy or in any way rely on it. Further, you should > notify the sender immediately and delete the email from your computer. > Whilst we have taken precautions to alert us to the presence of computer > viruses, we cannot guarantee that this email and any files transmitted with > it are free from such viruses. > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ >
Test.csv
Description: Binary data
