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 Ma
Hi!
How i do for transfer data from excel file to mysql?
Some example?
Thanks
if you dont want to write program:
use MsAccess.
thx
öö
- Original Message -
From: "Lists - Dustin Krysak" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 12, 2003 7:20 AM
Subject: Import from excel to MYSQL
> Is there an easy way to
I save it as a CSV and stick it through phpmyadmin...it can be a bit
clumsy (getting the delimiters to agree, mostly, which isn't exactly a
monumental hurdle) but it works great unless your sheet is bloody
massive and it runs past the timeout. I guess it'd be equally simple to
do a LOAD DATA INFIL
Is there an easy way to get an excel spread sheet imported into a MYSQL
database?
Any links to a tutorial?
Thanks in advance!
Dustin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ckson Miller [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 19, 2003 12:16 PM
To: Jay Blanchard; Phil Perrin; [EMAIL PROTECTED]
Subject: Re: Import from Excel to MySQL
I just had to solve this problem.
I needed to be able to have users load an excel file from a browser and have
it import.
To do
I just had to solve this problem.
I needed to be able to have users load an excel file from a browser and have
it import.
To do this I used perl to have the excel convert to csv on the server. This
was easy to accomplish using the CPAN module ParseExcel. The module comes
with a sample script
[snip]
Basically I need a way to import them from the Excel sheet to the
database so at that point I can manipulate the data and use a php script
of some sort to run a whois after extracting the domain name, and then
return the results to the database and have it attached to the domain
name.
[/snip
I'm a relative newbie to MySql, and I've got a small project I'm working
on and hopefully you folks can either point me in the proper direction
or give me a little help.
I have multiple spreadsheets in Excel format and in .csv format too,
that I would like to possibly import to a mysql database.
ello everybody
>I hope u can help me with this. I want to export tables from excel to
>mysql and i saved the file as .csv then clicked on browse to get Location
>of the textfile. But it doesnt work.
>I get for expl:
>SQL-query :
>
>"3","Technical"
Hello everybody
I hope u can help me with this. I want to export tables from excel to
mysql and i saved the file as .csv then clicked on browse to get Location
of the textfile. But it doesnt work.
I get for expl:
SQL-query :
"3","Technical"
"4","Technic
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
How do i import MS Excel Data into MySQL Tables??
T. Edison jr.
=
Rahul S. Johari (Director)
**
Abraxas Technologies Inc.
Homepage : http://www.abraxastech.com
Email : [EMAIL PROTECTED]
Tel : 91-4546512/4522124
***
At 3:31 PM -0400 9/11/01, Eugene Mah wrote:
>I was wondering if someone could direct me to some resources where I could
>teach myself how to export data from Excel to a MySQL database.
>
>I have a number of spreadsheets I use for data collection, and have recently
>set up a MySQL database to stash
I was wondering if someone could direct me to some resources where I could
teach myself how to export data from Excel to a MySQL database.
I have a number of spreadsheets I use for data collection, and have recently
set up a MySQL database to stash the data in. I've managed to figure out
how to
r" <[EMAIL PROTECTED]>
To: "Craig Westerman" <[EMAIL PROTECTED]>
Cc: "MySQL-List" <[EMAIL PROTECTED]>
Sent: Saturday, August 18, 2001 6:17 AM
Subject: Re: MS Excel to MySQL upload macro?
> Craig Westerman writes:
> > I have data I create daily in MS
Craig Westerman writes:
> I have data I create daily in MS Excel. I need to insert this data into
> MySQL data base on my web server every night. Does anyone here have a VB
> technique to upload to MySQL from Excel via a macro?
Hi,
There is an 'excel2mysql' perl script at the bottom of the
'Conv
On Fri, Aug 17, 2001 at 10:55:03PM -0500, Craig Westerman wrote:
> I have data I create daily in MS Excel. I need to insert this data into
> MySQL data base on my web server every night. Does anyone here have a VB
> technique to upload to MySQL from Excel via a macro?
VB?!?! Pth!
-F blahbla
I have data I create daily in MS Excel. I need to insert this data into
MySQL data base on my web server every night. Does anyone here have a VB
technique to upload to MySQL from Excel via a macro?
Thanks
Craig ><>
[EMAIL PROTECTED]
19 matches
Mail list logo
