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 get an excel spread sheet impor
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
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
