Save the excel file as a CSV text file, then use LOAD DATA INFILE
command to import. See the mysql manual for usage and example.
On May 8, 2008, at 4:49 AM, Lord Gustavo Miguel Angel wrote:
Hi!
How i do for transfer data from excel file to mysql?
Some example?
Thanks
--
MySQL General
Sure, it's usually fairly straightforward to transfer data. You can
export to a CSV or other delimited file, then use MySQL's LOAD DATA
INFILE command to read it in. See
http://dev.mysql.com/doc/refman/5.0/en/load-data.html
I haven't ever tried creating tables from something in Excel
If you have the Max Binaries of MySQL, do the following:
1) Export Excel Data to a CSV file (mydata.csv)
2) Goto MySQL and create table, without indexes to
accept the data (CREATE TABLE myImportCSV)
3) Change the table layout to accept CSV
i.e., ALTER TABLE myImport ENGINE = CSV;
Please note that
I do it all of the time, and once you get the hang of it this is quite easy.
The simple-minded way is to generate one SQL statement per row of the
original spreadsheet (assuming that each row of the spreadsheet corresponds
to a row in the data base table).
1. Create a new worksheet, if
As usual, Dan's suggestion is better than mine, especially for large amounts
of data (I usually work with perhaps 100 rows, at most). When you save a
spreadsheet as a text file, the columns will be delimited by tabs by
default.
Also, if you go with my suggestion you should probably surround any
From: Jerry Schwartz [EMAIL PROTECTED]
Sent: Wednesday, October 18, 2006 10:17 AM
To: 'Roberto William Aranda-W Roman' [EMAIL PROTECTED], 'MySQL List'
mysql@lists.mysql.com
Subject: RE: excel and Mysql?!
As usual, Dan's suggestion is better than mine, especially
Florida's First ISP
- Original Message -
From: David Ziggy Lubowa [EMAIL PROTECTED]
To: Eric Bergen [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, December 08, 2004 6:54 PM
Subject: Re: Excel 2 mysql
On Tuesday 07 December 2004 20:02, Eric Bergen wrote:
The easiest way
PROTECTED]
Sent: Wednesday, December 08, 2004 6:54 PM
Subject: Re: Excel 2 mysql
On Tuesday 07 December 2004 20:02, Eric Bergen wrote:
The easiest way to turn excel into MySQL is to have excel save the
file as a .csv (comma separated values) file and use the mysqlimport
utility or a load
]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, December 08, 2004 6:54 PM
Subject: Re: Excel 2 mysql
On Tuesday 07 December 2004 20:02, Eric Bergen wrote:
The easiest way to turn excel into MySQL is to have excel save the
file as a .csv (comma separated values) file and use
David Ziggy Lubowa wrote:
On Thursday 09 December 2004 14:33, David Ziggy Lubowa wrote:
On Wednesday 08 December 2004 05:07, Patrick Sherrill wrote:
David,
Please provide the complete LOAD DATA INFILE command you used.
mysql -e LOAD DATA INFILE '/home/dlubowa/clients.csv' INTO TABLE
- Original Message -
From: Ian Sales [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; Patrick Sherrill [EMAIL PROTECTED]
Sent: Thursday, December 09, 2004 9:53 AM
Subject: Re: Excel 2 mysql
David Ziggy Lubowa wrote:
On Thursday 09 December 2004 14:33, David Ziggy Lubowa wrote
Ziggy,
I'm not sure what you need help with.
If you want to get data into MySQL from Excel, consider saving the data (I
assume it is a table) as a CSV then using the LOAD DATA command to bring the
data into a temporary table in MySQL. Take a look at the command in the help
pages.
Regards,
Adam
On Tuesday 07 December 2004 20:02, Eric Bergen wrote:
The easiest way to turn excel into MySQL is to have excel save the
file as a .csv (comma separated values) file and use the mysqlimport
utility or a load data infile query to insert it into a table in
cheers guys, i have managed to change
:[EMAIL PROTECTED]
Sent: 08 December 2004 23:55
To: Eric Bergen
Cc: [EMAIL PROTECTED]
Subject: Re: Excel 2 mysql
On Tuesday 07 December 2004 20:02, Eric Bergen wrote:
The easiest way to turn excel into MySQL is to have excel save the
file as a .csv (comma separated values) file and use
, 2004 6:54 PM
Subject: Re: Excel 2 mysql
On Tuesday 07 December 2004 20:02, Eric Bergen wrote:
The easiest way to turn excel into MySQL is to have excel save the
file as a .csv (comma separated values) file and use the mysqlimport
utility or a load data infile query to insert it into a table
David Ziggy Lubowa wrote:
cheers guys, i have managed to change my excel file into a .csv and done a
LOAD DATA INFILE and dumped the data in the mysql db the only problem though
that all the data is going into one field in the table yet it is comma
separated with the exact columns.
How can i
[snip]
i know this has been discussed but looking through the archives i have
more
less hit a stand still , i have one big excel file which has data i
would
like to extract., Now i am no expert in perl neither am i in php , i
have
looked at some tools like navicat but i dont see where you
Jay Blanchard wrote:
[snip]
i know this has been discussed but looking through the archives i have
more
less hit a stand still , i have one big excel file which has data i
would
like to extract., Now i am no expert in perl neither am i in php , i
have
looked at some tools like navicat but i
The easiest way to turn excel into MySQL is to have excel save the
file as a .csv (comma separated values) file and use the mysqlimport
utility or a load data infile query to insert it into a table in
MySQL.
-Eric
On Tue, 7 Dec 2004 16:02:23 -0800, David Ziggy Lubowa
[EMAIL PROTECTED] wrote:
From Excel, save the file as a CSV (comma separated values) use either
mysql load data infile in an insert query or use phpmyadmin to import the
csv into a table in your database.
Regards
Assey
On Tue, 7 Dec 2004, David Ziggy Lubowa wrote:
Hey guys ,
i know this has been discussed but
to load files into mysql:
create a table:
create table newtable (column1 int(10),column2 varchar(250));
import the data:
load data infile '/path/to/file/file.csv' into table newtable
fields terminated by ',' lines terminated by '\n'
Alia Mikati wrote:
Hello everybody
I hope u can help me
At 3:58 -0800 3/27/02, Thomas Edison Jr. wrote:
How do i import MS Excel Data into MySQL Tables??
One way: save it as a tab-delimited file, then import it
with mysqlimport.
If you don't want to mess around pointing and clicking to save
an Excel file as a tab-delimited file, try using this Perl
22 matches
Mail list logo