There is a module for Perl which can read Excel. Then there is DBI for
accessing MySQL. Use both to transfer data.
If under Windows, you coudl also use ODBC and some ActiveX control
under Visual Basic for quick and dirty transfer scripting.
----- Original Message -----
From: "Chris L. Gray" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 5:15 PM
Subject: Importing spreadsheet data into MySQL
Is it possible to import spreadsheet data (Excel) into MySQL? I have
data on about 2,500 retail locations that I must place into a database
on the web and I do not want to type them by hand if I can avoid it.
Thanks,
Chris Gray
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.256 / Virus Database: 129 - Release Date: 5/31/2001
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
