[PHP] Importing Text into Database - Can you recommend a tutorial?
I'm wading through some of the MySQL literature (whew!), but I'm looking for the quickest way to create some tables and get them online. I just downloaded a software program called EMS MySQL Manager, which appears to work well with phpMyAdmin and makes some functions even easier. Especially useful is a function that imports text from another file, such as a spreadsheet. I haven't been able to finish an import yet, because I'm still learning how to make the tables to import it into; all of my tables have errors of one kind or another. I just wondered if anyone on this list is aware of a particularly helpful tutorial or strategy for doing this sort of thing - or do you just have to wade through all the tutorials and construct your tables, one row/column/function at a time? I have a number of spreadsheet databases, and I'm just looking for the quickest way to get them into a MySQL/PHP database. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Importing Text into Database - Can you recommend a tutorial?
[snip] I have a number of spreadsheet databases, and I'm just looking for the quickest way to get them into a MySQL/PHP database. [/snip] If they (the spreadsheets) are really set up like databases then you can save them as CSV files and import them directly with very little pain. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Importing Text into Database - Can you recommend a tutorial?
[snip] [snip] I have a number of spreadsheet databases, and I'm just looking for the quickest way to get them into a MySQL/PHP database. [/snip] If they (the spreadsheets) are really set up like databases then you can save them as CSV files and import them directly with very little pain. [/snip] Ooops, sorry. Google for 'import CSV into MySQL' or hit the MySQL web site -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Importing Text into Database - Can you recommend a tutorial?
I have a number of spreadsheet databases, and I'm just looking for the quickest way to get them into a MySQL/PHP database. Hi, You can pick the headers from the speadsheets to construct the tables, export from the spreadsheets to .csv and import it to the new tables Humberto Silva World Editing Portugal -Original Message- From: Freedomware [mailto:[EMAIL PROTECTED] Sent: sexta-feira, 23 de Janeiro de 2004 12:42 To: [EMAIL PROTECTED] Subject: [PHP] Importing Text into Database - Can you recommend a tutorial? I'm wading through some of the MySQL literature (whew!), but I'm looking for the quickest way to create some tables and get them online. I just downloaded a software program called EMS MySQL Manager, which appears to work well with phpMyAdmin and makes some functions even easier. Especially useful is a function that imports text from another file, such as a spreadsheet. I haven't been able to finish an import yet, because I'm still learning how to make the tables to import it into; all of my tables have errors of one kind or another. I just wondered if anyone on this list is aware of a particularly helpful tutorial or strategy for doing this sort of thing - or do you just have to wade through all the tutorials and construct your tables, one row/column/function at a time? I have a number of spreadsheet databases, and I'm just looking for the quickest way to get them into a MySQL/PHP database. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Importing Text into Database - Can you recommend a tutorial?
Jay Blanchard wrote, Ooops, sorry. Google for 'import CSV into MySQL' or hit the MySQL web site Humberto Silva wrote: You can pick the headers from the speadsheets to construct the tables, export from the spreadsheets to .csv and import it to the new tables Wow, thanks for the tips. I wasn't even aware of CSV - something that will be very useful for me. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Importing Text into Database - Can you recommend a tutorial?
there is a program that is called mySQL Front it has a fucntion to import CSV (comma delimited) files into a DB. Just google for it. HTH Angelo -Original Message- From: Freedomware [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 2:42 PM To: [EMAIL PROTECTED] Subject: [PHP] Importing Text into Database - Can you recommend a tutorial? I'm wading through some of the MySQL literature (whew!), but I'm looking for the quickest way to create some tables and get them online. I just downloaded a software program called EMS MySQL Manager, which appears to work well with phpMyAdmin and makes some functions even easier. Especially useful is a function that imports text from another file, such as a spreadsheet. I haven't been able to finish an import yet, because I'm still learning how to make the tables to import it into; all of my tables have errors of one kind or another. I just wondered if anyone on this list is aware of a particularly helpful tutorial or strategy for doing this sort of thing - or do you just have to wade through all the tutorials and construct your tables, one row/column/function at a time? I have a number of spreadsheet databases, and I'm just looking for the quickest way to get them into a MySQL/PHP database. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Disclaimer This e-mail transmission contains confidential information, which is the property of the sender. The information in this e-mail or attachments thereto is intended for the attention and use only of the addressee. Should you have received this e-mail in error, please delete and destroy it and any attachments thereto immediately. Under no circumstances will the Cape Technikon or the sender of this e-mail be liable to any party for any direct, indirect, special or other consequential damages for any use of this e-mail. For the detailed e-mail disclaimer please refer to http://www.ctech.ac.za/polic or call +27 (0)21 460 3911 Disclaimer This e-mail transmission contains confidential information, which is the property of the sender. The information in this e-mail or attachments thereto is intended for the attention and use only of the addressee. Should you have received this e-mail in error, please delete and destroy it and any attachments thereto immediately. Under no circumstances will the Cape Technikon or the sender of this e-mail be liable to any party for any direct, indirect, special or other consequential damages for any use of this e-mail. For the detailed e-mail disclaimer please refer to http://www.ctech.ac.za/polic or call +27 (0)21 460 3911 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Importing Text into Database - Can you recommend a tutorial?
CSV just stands for comma separate values. CSV support is pretty common as a way of moving data between applications, and most all spreadsheets support it. It's just a text file like this: Value1,value2,value3 Sometimes you might have a string delimiter like so: Value1,value2,string 1 here,value3 -Original Message- From: Freedomware [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 5:23 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] Importing Text into Database - Can you recommend a tutorial? Jay Blanchard wrote, Ooops, sorry. Google for 'import CSV into MySQL' or hit the MySQL web site Humberto Silva wrote: You can pick the headers from the speadsheets to construct the tables, export from the spreadsheets to .csv and import it to the new tables Wow, thanks for the tips. I wasn't even aware of CSV - something that will be very useful for me. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
