I don't know; never tried it that way _____
From: axis [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 12, 2006 9:37 PM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: RE: What's the best way to INSERT a long list of email addresses and names into a TABLE? HTML_MESSAGE,MIME_HTML_ONLY autolearn=disabled version=3.1.4 X-Spam-Checker-Version: SpamAssassin 3.1.4 (2006-07-25) on farm03 X-NAS-Classification: 0 X-NAS-MessageID: 45965 X-NAS-Validation: {9F3F1FB5-9CCB-44C4-8345-B1DFB7F0F848} Thank you for your quick reply, and FROM only works with absolute paths? Does it work with '../../Customer_Data.csv'? Axis On 9/12/2006 10:22:01 PM, Don ([EMAIL PROTECTED]) wrote: > Presuming your csv is set up in the structure of your table - this may > help > > > > BULK INSERT tablename > > FROM 'C:\filelocation\my_data.csv' > > WITH > > ( > > FIELDTERMINATOR =',', > > ROWTERMINATOR ='\n' > > ) > > > > I am going through a SQL class and this is the method we are using to > bulk > > insert into our tables. Works like a champ. > > > > Don > > > > -----Original Message----- > > From: axis [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, September 12, 2006 9:10 PM > > To: [EMAIL PROTECTED] > > Cc: mysql@lists.mysql.com