4 {{ upvoteCount | shortNum }}
4 {{ upvoteCount | shortNum }}

SQL database to convert to XLS

by Balazs
3 replies
Hi,


I have just bought a forum, I am about to install but before I do so, I would like to convert the SQL database to xls file (extract the contact)

any idea to do so?
right now I am having some issues installing it to myphpAdmin. it is about 90 Mbyte, ah, anyways, is there a good way to convert it somehow?

Cheers
Balazs
#convert #database #sql #xls
  • Profile picture of the author Bryan O'Neil
    XLS? Why on earth?!?

    Just export the SQL database (you'll get a .sql file) and import it to the server you're moving the forum to.

    As for yourself - you'll still have the .sql file which you can work with using any one of the thousands desktop-based SQL managers or phpMyAdmin.

    Or - pay someone $10 to do it all for you.
    {{ DiscussionBoard.errors[2666347].message }}
  • Profile picture of the author mywebwork
    It is an odd request!

    One way you can do this on a is with the MySQL GUI tool - well at least you can pump the results of a query into an Excel or XML file.

    But as Bryan mentioned the most logical thing to do is just use the SQL file itself.

    Bill
    {{ DiscussionBoard.errors[2666720].message }}
  • Profile picture of the author D_M_S
    You need to provide more info to properly answer this question.

    (1) which database package are you talking about? SQL Server? MySQL? PostGres? SQLLite?

    (2) what is your comfort level in working with databases?

    (3) which specific info do you need? Just email addresses from your users?
    Signature

    Looking for new affiliates for a penny auction web site -- please send me a PM

    {{ DiscussionBoard.errors[2666809].message }}

Trending Topics