SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Evangelist
    Join Date
    Mar 2011
    Posts
    423
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Microsoft Excel with MySQL

    Hi there,

    I am about to begin designing a table containing over 2,000 products. I intend to use PHPMyAdmin to design the fields in the table.

    Whenever I search for using Microsoft Excel with MySQL no one seems to recommend it. I think it would be easier?

    If I want to add a new product using Microsoft Excel I would just export the table from PHPMyAdmin as an Excel Spreadsheet, enter the new information about the new product as a new entry. Then import the Excel file into PHPMyAdmin. Similarly, if I want to edit some prices I export, change and import the changes.

    What people have recommended is having a login at the web site. And then create some "add new product" and "edit" pages, whereby as a webmaster I can edit the data and other people in the office whom are less web-site-design-savvy can log in and add new products and edit existing prices, etc..

    What do you suggest? How easy is it using Microsoft Excel with MySQL? Why do you suggest what you suggest? What experience do you have with Microsoft Excel?

    Thanks for your help,

    Matt.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,330
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by MatthewBOnline View Post
    Whenever I search for using Microsoft Excel with MySQL no one seems to recommend it. I think it would be easier?
    dumping the table, adding a couple of rows in excel, then re-importing the table... is the hard way

    the easy way is using a front end tool like HeidiSQL

    srsly, no comparison
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •