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.
