Sorry if this is very obvious, but I'm trying to put a database I have, online, so I can have it dynamically linked to a new website I am designing based around a property website - i.e I can design the database to look up fields online, instead of inputting each property manually into each webpage. I have a database in excel which has obvious fields like name, address, email, website, etc and I want to know if and how I can directly upload this to my web host (I have use of MyPHP and MySQL with my web host) directly without having to manually create a table and fields etc using MySql, and if this is possible, can I create a HTML form (PHP?) to write to and update this database with new additions. Any and all useful info/links appreciated, and thank you in advance
If I am right, you wish to use an excel file to fill in a database, including table creation. You will have to go by manually creating the table structure, and filling it with category names etc. Once you create the table manually, you can then use a simple php script to write/ edit / delete records from the mysql. Bye
Thank you for that Jeet. So are you saying it would be easier if I had a db (Access) database - would that be easier? And where could I find a script I could customize to suit any uploads?
I was thinking about this. Here's what you can do to make this easier: * make the table structure on mysql using phpmyadmin, or php script. (Just a few lines, very easy) * Export the excel file as "tab delimited text file" and upload text file to server. (File >> Save as...) * Now make a php script which reads this text file, and "INSERTS" records to mysql database. (Not very difficult again. General php...) Things to take care about: * When you save the file as text file, long text fields will be saved between (") sign. Before inserting, you must get rid of them. You can do this manually, or a replace command in php script also. * Make sure to remove any header/footer info you have in excel file. Can also be removed later from the text file. This leaves you with "records" only. About the upload script, I am not sure if there are any to upload databases to server. There are ones which help in uploading "big" databases, but they require that the format of both databases be the same. A "dump" created using phpmyadmin to be imported into another mysql database. But I don't think that they convert from "access" to "mysql". Bye
You can also do the download from db site instead of uploading to web site. If you can have ftp or web server at db location. Maybe you can mount disk from db location to webserver (nfs or windows file sharing)? Then it is easy to read database.