csv import issues - good solution found

2009-10-06 Thread Patrice Olivier-Wilson
A week or so ago, I was seeking a solution for breaking lines for importing csv to phpmyadmin interface Found a slick solution: http://csv2sql.evandavey.com/ create table in database, upload the csv file to above page, copy/paste the resulting code into SQL field for the database (not the ta

Re: CSV import

2007-05-31 Thread Mogens Melander
Import your CSV-data into a temporary table, using mysqlimport, and throw a bit of SQL at it might do the trick, but then again, not knowing the layout of your table, nor the data you want to import, i'm only guessing. On Mon, May 28, 2007 16:57, Sharique uddin Ahmed Farooqui wrote: > Both PhpMyAd

Re: CSV import

2007-05-28 Thread Martijn Tonies
> Both PhpMyAdmin and SQLYOG doesn't support customised mapping. > My cvs data structure is diff from mysql table. I just want to import values > for one field only. Database Workbench does, see www.upscene.com > Previously I was using Mysql Front but it crashes. Also this s/w very old > and d

Re: CSV import

2007-05-28 Thread Baron Schwartz
Sharique uddin Ahmed Farooqui wrote: Both PhpMyAdmin and SQLYOG doesn't support customised mapping. My cvs data structure is diff from mysql table. I just want to import values for one field only. Previously I was using Mysql Front but it crashes. Also this s/w very old and discontinued. Why my

Re: CSV import

2007-05-28 Thread Sharique uddin Ahmed Farooqui
Both PhpMyAdmin and SQLYOG doesn't support customised mapping. My cvs data structure is diff from mysql table. I just want to import values for one field only. Previously I was using Mysql Front but it crashes. Also this s/w very old and discontinued. Why mysql doesn't implement it in MysqlAdmin?

Re: CSV import

2007-05-28 Thread Geoffroy Cogniaux
Hi, It can be done easily with PhpMyAdmin, but it is not in .net 2007/5/28, Sharique uddin Ahmed Farooqui <[EMAIL PROTECTED]>: I want to import data from a CSV file in a table. MySql admin doesn't support import from CSV files. Format of data is different from structure of table. Is there any

RE: CSV import

2007-05-28 Thread Sandesh Nair
Try SQLYOG software Thanks & Regards, Sandesh Nair -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sharique uddin Ahmed Farooqui Sent: Monday, May 28, 2007 11:56 AM To: mysql@lists.mysql.com; [EMAIL PROTECTED] Subject: CSV import I want to im

CSV import

2007-05-27 Thread Sharique uddin Ahmed Farooqui
I want to import data from a CSV file in a table. MySql admin doesn't support import from CSV files. Format of data is different from structure of table. Is there any app/snippet written for this task in .net , which I can modify according to my need. -- Sharique uddin Ahmed Farooqui (C++/C#

RE: sql CSV import

2003-02-01 Thread Sherzod Ruzmetov
: Dobromir Velev : [EMAIL PROTECTED] : www.websitepulse.com : : : - Original Message - : From: "Andrew" <[EMAIL PROTECTED]> : To: <[EMAIL PROTECTED]> : Sent: Thursday, January 30, 2003 12:48 : Subject: RE: sql CSV import : : : &g

Re: sql CSV import

2003-01-31 Thread Dobromir Velev
: Thursday, January 30, 2003 12:48 Subject: RE: sql CSV import > > Hi all I am trying to import a csv file from MySQL and keep getting an error on > line one. > Is there an alternative way to import a csv file other than using phpmyadmin? > > I exported the file from MySQ

RE: sql CSV import

2003-01-30 Thread Andrew
Hi all I am trying to import a csv file from MySQL and keep getting an error on line one. Is there an alternative way to import a csv file other than using phpmyadmin? I exported the file from MySQL but can't import it back in, any ideas? Andrew -