Results 1 to 4 of 4

Thread: Insert data from an Excel file into MySQL.

  1. #1
    Join Date
    Nov 2009

    Insert data from an Excel file into MySQL.

    I have a lot of data that is on media files such as Access or Excel and I want to insert these data into a MySQL database without having to copy. I am using Microsoft office 2003. Second thing Automatic change of colors in a chart (histogram) with EXCEL. How can I do this. I had tried with font colors but not working.

  2. #2
    Join Date
    May 2008

    Re: Insert data from an Excel file into MySQL.

    Here we will open our file that contains the data and thus be aware of the number of fields (columns) and the types of values that we would get output. In column A we have numbers (certainly not in such numbers stored in our field but not a problem) and Column B names. Establishment of database of destination. Go to external Data> More> ODBC Database.

  3. #3
    Join Date
    Apr 2008

    Re: Insert data from an Excel file into MySQL.

    Open a new Excel file which contains data. If should consist of proper tables and columns. I am using a budget set file. You could be very well in putting a bit more formal. Then right click over> Format Cells. Choose conditional formatting here. Select the appropriate options and then you can change the relevant colours.

  4. #4
    Join Date
    Mar 2009

    Re: Insert data from an Excel file into MySQL.

    Here I will show you how to use conditional formatting. If my expense is equal or superior to them, I therefore consider that the goal is not reached. Therefore I choose an indicator "red" to indicate failure and a "green" for success. So select cell B2 the data cell. Then click the Format menu and then Conditional Formatting. Fill in the fields as follows. Condition 1 - Greater than or equal to etc.

Similar Threads

  1. How to insert common data from on Excel File to another
    By Rish!On in forum MS Office Support
    Replies: 2
    Last Post: 17-02-2012, 01:10 PM
  2. Replies: 2
    Last Post: 22-01-2012, 10:59 AM
  3. How to Insert data into MySQL table
    By Mahendra varma in forum Software Development
    Replies: 4
    Last Post: 04-10-2009, 04:42 AM
  4. Insert Excel data into Word
    By Rivita in forum Windows Software
    Replies: 2
    Last Post: 24-09-2009, 02:09 PM
  5. export data in the bd Mysql to the Excel file
    By Actionguy in forum Software Development
    Replies: 6
    Last Post: 02-03-2009, 06:23 PM

Posting Permissions

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