Import from Excel to MySQL

[Phil Perrin]

------=_NextPart_000_0001_01C3663D.5E3EAD70
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

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. All of the
excel and csv files have is one huge colum and they are only 1 cell on
each line. An estimate of 7k-8k domain names I need to run a whois on.

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.

Any help would be greatly appreciated!

~Phil

------=_NextPart_000_0001_01C3663D.5E3EAD70--

[Jackson Miller]

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 that basically does the trick.

I am planning to use perl2exe to create an executable of my xls2csv perl
script. But the perl script is working fine. I use exec() to call the perl
script.

-Jackson

On Tuesday 19 August 2003 10:49, Jay Blanchard wrote:
> [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]
>
> Export the Excel to csv, then import the csv to MySQL. There are classes
> for PHP that will read the binary data directly from Excel, but they are
> costly...i.e. http://www.web-aware.com/biff/
>
> HTH!

--
jackson miller

cold feet creative
615.321.3300 / 800.595.4401
jac...@coldfeetcreative.com


cold feet presents Emma
the world's easiest email marketing
Learn more @ http://www.myemma.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=my...@freebsd.csie.nctu.edu.tw

[Landers, Jason]

I am also working on something like this but am taking a different approach.
Basically I'm creating an Excell Add-in in VBA that adds a button to the
Excel toolbar. When a user clicks it I take the highlighted rows and columns
and verify that they are in the proper format and everything looks good then
import them into the database with the MySQL ODBC driver and VBA. It's more
work up front than your solution but for the PHB it's a lot more comfortable
than learning a new custom application and process. To them it's just Office
;)

it import.

script.

-Jackson

http://lists.mysql.com/mysql?unsub=jlan...@visualnetworks.com

[ma...@monitor.wc.lt]

Use http://excel2mysql.esy.es/ Excel to SQL online converter- Generates SQL insert script from xlsx , xls , csv files to easy import in MySQL database or MS SQL server.Hope it helps !