How difficult is it to transfer an excel file to a mysql database? Is there any easy scripts that can do it? thanks, Mike
I have a tool that implements this one.xls to mysql Navicat MySQL-very useful tools in transffering and converting database into different types. You can download it here navicat.com/.. Hope this one help.Cheers!
thanks so basicly you're saying if you have excel you can transfer it to mysql quickly and easily, with the same structure of course..?
Yes..very useful software.. If you have problems with the software you can ask for my help. Im not sure you will have problems with that. It's easy to use..you dont have to use PHPmyAdmin for this one.just enter the host username and password.
When I need to transfer XLS data into MySQL I simply export the XLS as a CSV file and import that into MySQL via phpMyAdmin Works great since phpMyAdmin natively supports CSV.
Nice way of transferring your xls.But I think it is more complicated when you do this unlike using this user-friendly tools by navicat.
i want to import a file which is in csv format i used phpmyadmin but some error is coming. Let me tell u wha t the error is "Invalid field count in CSV input on line 1." so can any1 plzzzzz help
Blarg ... $100 for this!11!?!?!?1 ... where's open source when you need it. Nice avatar!!!! That method works great for a simple csv but how about a full spreadsheet with tables? How about creating each table in the db on the fly? I can see many practical applications for this, mainly because excel is a much better visual tool than phpmyadmin ever could dream of being. 1. build it in excel 2. dump into mysql 3. structure is transferred flawlessly (table names, column names, data format, etc) I know that excel can be read by some open source php programs (for example), so heading from xls directly to mysql isn't a far stretch ... but believe it or not, I couldn't find anything freely available. Now, in excel I know you can export to XML format. Doing this gives a file structure which would be easy to transfer to a sql format and dump in place. That's a couple hour script at most .. the xml is nicely formatted and looks like this In php I see 3 preg_match_all loops (1 for tables, 1 for each row, 1 for each field) and some creative array output ... < 100 lines total code. I don't need this at the moment, but it would have been terribly useful in the past. Many of my db driven sites could have been created in 1/2 the time with a tool of this nature. Sorry, but I don't have the time to whip this one up right now ... subscribing to this thread though hoping that someone else will pick up the slack. If not, someday I might find some time for it.
thanks for the help!!!!! now can u tell me how to search a record from the database and display all the field related to that search in text fields so that you can update information after clicking update.
You should look into CRUD activities for SQL/PHP. I could help but it would have to be for a charge. Asking this as a separate question over at the php section of DP will yield much better results ... but still, I don't think anyone is doing it for you.
I am actually surprised that you can't do it from excel, if you export it as a tab deliminated or comma deliminated I thought that may work. Maybe not, just a thought.
Try http://www.cloveretl.com/products/community-edition I haven't tried it, but it's free and is supposed to work.