Re: [PHP-DB] Re: Excel to MySQL
As suggested by David, save the excel file as CSV file then you can insert the data into database through command like LOAD INFILE for MYSQL with best wishes balwant On Tue, 2005-01-25 at 12:34, David Robley wrote: On Tuesday 25 January 2005 08:07, Novice Learner wrote: Hello, I have an Excel worksheet with a database in it. I would like to move this data to the database on the server that would work with my .php files. Is there a way? I apologize if I posted this question on the wrong list. Thank you, One option might be to export the Excel data as csv, then use whatever option your database provides to import the csv data. -- David Robley Nostalgia isn't what it used to be. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Excel to MySQL
Many thanks to all - Do you Yahoo!? All your favorites on one personal page Try My Yahoo!
[PHP-DB] Re: Excel to MySQL
On Tuesday 25 January 2005 08:07, Novice Learner wrote: Hello, I have an Excel worksheet with a database in it. I would like to move this data to the database on the server that would work with my .php files. Is there a way? I apologize if I posted this question on the wrong list. Thank you, One option might be to export the Excel data as csv, then use whatever option your database provides to import the csv data. -- David Robley Nostalgia isn't what it used to be. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Excel to MySQL??
use LOAD DATA (plus parameters) to import excel-files and other text-files into mysql chris Am Sonntag den, 30. Juni 2002, um 01:23, schrieb Manuel Lemos: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Excel to MySQL??
i forgot: LOAD DATA is a mysql-command http://www.mysql.com/doc/L/o/Loading_tables.html chris Am Montag den, 1. Juli 2002, um 14:16, schrieb Christian Rellstab: use LOAD DATA (plus parameters) to import excel-files and other text-files into mysql chris Am Sonntag den, 30. Juni 2002, um 01:23, schrieb Manuel Lemos: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Excel to MySQL??
Hello, On 06/29/2002 06:21 PM, Chase wrote: Does anyone know of a way that I can export an Excel spreadsheet to a file that I can import to MySQL? I found a program that will do this for Access, but I would rather leave Access out of this if possible. I think you can do it via ODBC under Windows. Anyway, if you are running PHP under Windows, you may as well use COM objects to access to Excel spreadsheets. In that case you may want to try this class: http://www.phpclasses.org/browse.html/package/86.html -- Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] RE: Excel to MySQL
You could try the MyODBC driver. On the www.mysql.com website I think. Then you won't need CSV or any other type of import file. Tony -Original Message- From: Mikusch, Rita [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 17, 2001 5:05 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] RE: Excel to MySQL I do this fairly often (actually from MSSQL to Access to Excel to MySQL -- I'm sure there's a shorter route!) I convert the Excel file to a tab delimited file. I do run into two problems: a) some of the text entries are surrounded by double quotes and some aren't (some kind of Excel weirdness). So I open it up in a text editor and delete all the quotes. I use the programmers file editor which is about a zillion years old, hasn't been updated for years, but deletes those quotes in milliseconds. b) sometimes users enter hard-returns into the text data they enter into the windows database (the source of my excel file). This will convert into a hard return in your tab delimited text file. I run through the list manually to find the hard returns and delete them. My list is only 10,000 long and it is formatted in such a way that makes these hard returns easy to see! I'm sure others on the list have a much better way of dealing with this. I have an auto increment field in my table so I add an additional numbered column in Excel and number it appropriately. One day when I have time I'll actually find a more efficient way of doing all this! good-luck rita. -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 16, 2001 10:58 PM To: [EMAIL PROTECTED] Subject: Excel to MySQL Hi there everyone, What is the best way to convert an Excel spreadsheet into a MySQL database? Should I save it as a comma'd file or is there a better way? If I have to save it as a comma'd text file, is there anything special I should do first? I would normally enter the data manually on my server, but we are talking in excess of 15000+ entries here which is way too many to add manually. Thanks for all your help. Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: RE: [PHP-DB] RE: Excel to MySQL
Check this out: http://gertrude.anglia.ac.uk/webteam/tips/php_sql/odbc.htm Step by step instructions on how to connect Access to MySQL (from PC/workstation to remote server) Cheers. Russ On Thu, 18 Oct 2001 13:44:15 +0100 Tony McCrory [EMAIL PROTECTED] wrote: You could try the MyODBC driver. On the www.mysql.com website I think. Then you won't need CSV or any other type of import file. Tony -Original Message- From: Mikusch, Rita [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 17, 2001 5:05 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] RE: Excel to MySQL I do this fairly often (actually from MSSQL to Access to Excel to MySQL -- I'm sure there's a shorter route!) I convert the Excel file to a tab delimited file. I do run into two problems: a) some of the text entries are surrounded by double quotes and some aren't (some kind of Excel weirdness). So I open it up in a text editor and delete all the quotes. I use the programmers file editor which is about a zillion years old, hasn't been updated for years, but deletes those quotes in milliseconds. b) sometimes users enter hard-returns into the text data they enter into the windows database (the source of my excel file). This will convert into a hard return in your tab delimited text file. I run through the list manually to find the hard returns and delete them. My list is only 10,000 long and it is formatted in such a way that makes these hard returns easy to see! I'm sure others on the list have a much better way of dealing with this. I have an auto increment field in my table so I add an additional numbered column in Excel and number it appropriately. One day when I have time I'll actually find a more efficient way of doing all this! good-luck rita. -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 16, 2001 10:58 PM To: [EMAIL PROTECTED] Subject: Excel to MySQL Hi there everyone, What is the best way to convert an Excel spreadsheet into a MySQL database? Should I save it as a comma'd file or is there a better way? If I have to save it as a comma'd text file, is there anything special I should do first? I would normally enter the data manually on my server, but we are talking in excess of 15000+ entries here which is way too many to add manually. Thanks for all your help. Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] #---# Believe nothing - consider everything Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam www.theruss.com #---# -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
