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
Two main ways:
1. Dump your tables to a file and import them using the text import filter.
2. Install MyODBC and open a connection to the MySQL tables in Excel.
Since Excel is a proprietary file format, MySQL does not support it. Also,
bear in mind that Excel has a 65,535 row limit hard coded
How do I export from mysql into excel format?
Directly - use SELECT INTO OUTFILE and set up as a CSV, and open in excel
Indirectly - use a programming language and library to write an Excel
binary (php or perl with spreadsheetwrite_excel)
HTH
Jeff
--
MySQL General Mailing List
For list
: Re: excel
How do I export from mysql into excel format?
Directly - use SELECT INTO OUTFILE and set up as a CSV, and open in excel
Indirectly - use a programming language and library to write an Excel
binary (php or perl with spreadsheetwrite_excel)
HTH
Jeff
--
MySQL
Hmm... I use ASP.net, is there any instruction that I can use to use
ASP.net
to export into excel or is there another way?
Well, I know nothing of ASP.net, but you should be able to select from
mysql, then instantiate excel via COM to write the binary.
Jeff
How do I export from mysql
Alright, I will look into it.
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]
Sent: Friday, August 20, 2004 10:09 AM
To: Scott Hamm
Cc: 'Mysql ' (E-mail); Scott Hamm
Subject: RE: excel
Hmm... I use ASP.net, is there any instruction that I can
Professional
[EMAIL PROTECTED]
Triand, Inc.
www.triand.com
O: (512) 248-2287
M: (713) 252-4688
-Original Message-
From: Andrew Pattison [mailto:[EMAIL PROTECTED]
Sent: Friday, August 20, 2004 8:01 AM
To: [EMAIL PROTECTED]
Subject: Re: excel
Two main ways:
1. Dump your tables to a file
: excel
Hmm... I use ASP.net, is there any instruction that I can use to use
ASP.net
to export into excel or is there another way?
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]
Sent: Friday, August 20, 2004 10:02 AM
To: Scott Hamm
Cc: 'Mysql ' (E-mail)
Subject: Re: excel
On 20 Aug 2004 at 10:09, [EMAIL PROTECTED] wrote:
Hmm... I use ASP.net, is there any instruction that I can use to use
ASP.net
to export into excel or is there another way?
Well, I know nothing of ASP.net, but you should be able to select from
mysql, then instantiate excel via COM to
Please read the attached file.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I save as CSV (MS-DOS).
I then import into MySQL using SqlYog and the following parameters:
Line terminator \r\n
Delimiter ,
Strings Optionally surrounded by
That gives me a successful import every time. I have tried other variations
and achieved same results as you - 'jumbled'
You can use MS Query and MyODBC to allow your customers to access the MySQL
database.
-Original Message-
From: Bernd Jagla [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 9:12 AM
To: mysql
Subject: Excel(2002) and mysql4
My costomers are using Excel, so I am looking into
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
You could save it as a cvs file and inport it using LOAD DATA INFILE
- Original Message -
From: chris ochap [EMAIL PROTECTED]
To: Mailing List MySQL [EMAIL PROTECTED]
Sent: Friday, July 05, 2002 6:26 PM
Subject: excel spreadsheet to mysql
is there a way to import a large excel
Hi.
Export it as CSV file and import it to MySQL, e.g. using LOAD DATA
INFILE.
Greetings,
Benjamin.
On Fri 2002-07-05 at 13:26:26 -0800, [EMAIL PROTECTED] wrote:
is there a way to import a large excel spreadsheet into mysql? thanks.
chris.
--
[EMAIL PROTECTED]
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
I am not a Perl Guru. How would I set up this environment? Or is there
another way to go from excel to MySQL?
--
Joseph Ferrara
Member of the Engineering Staff
LOCKHEED MARTIN
Naval Electronics Surveillance Systems
Save to a CSV (comma-delimited file) from Excel, and take a look at the
"load data infile..." command within the mysql documentation.
regards,
P
On
Thu, 15 Feb 2001, Joe Ferrara wrote:
I am not a Perl Guru. How would I set up this environment? Or is there
another way to go from excel
Try Mascon's CopyPaste or Import Export: http://www.scibit.com/Mascon
-Original Message-
From: Ashley M. Kirchner [mailto:[EMAIL PROTECTED]]
Sent: 31 January 2001 20:19
To: MySQL Mailing List
Subject: Excel-MySQL
Not sure if this was ever asked, but I'm fighting a
38 matches
Mail list logo
