Save as .csv file and then use http://www.mysql.com/doc/L/O/LOAD_DATA.html
Hope this helps
Simon
-----Original Message-----
From: Chris L. Gray [mailto:[EMAIL PROTECTED]]
Sent: 06 June 2001 14:15
To: [EMAIL PROTECTED]
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
