I have a database in Excel format and want to import it to a forum only problem is its not originally from a forum so would need tweaking anyone on here do this ??
Do you want to post it as text, in a forum posting, or attach it as a file? For a forum posting, if you're on windows, and all the data is on one worksheet inside the Excel file, try: ctrl+a to select all ctrl+c to copy all now go to forum posting and ctrl+v to paste it into the posting The text should be tab-delimited text which is easy for other users to copy and paste back into an Excel file. But test it as every forum is different. Also, if you have more than one worksheet, you may have to do it separately. Hope this is what you needed...
i think you mis-understood me i want it adding to the forums MySQL so that they show on the forum as joined members thanks for your reply though
Oh, sorry, I did misunderstand. If you paste the text from Excel into a notepad file (instead of a forum post), you can then massage it into shape as mysql INSERT commands (make sure they match your current data structure). Then load it into mysql in two ways: If you have access to phpmyadmin -- You can navigate to the SQL form for your mysql db in phpmyadmin, paste in the text, and let it fly. Or If you are a command line person, save the text file to your server, fire up mysql, and use "source filename.txt" to insert it. This is a very general (You really have to have your INSERT commands perfect so the right data ends up in the right place), but hope it gets you pointed in the right direction. And as spyrit said it might be worth looking for more automated approaches.