Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Insert data from an Excel file into MySQL.

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 24-11-2009
Member
 
Join Date: Nov 2009
Posts: 4,489
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.

Reply With Quote
  #2  
Old 24-11-2009
Member
 
Join Date: May 2008
Posts: 4,828
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.
Reply With Quote
  #3  
Old 24-11-2009
Member
 
Join Date: Apr 2008
Posts: 4,086
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.
__________________
Ram requirement for various OS
Reply With Quote
  #4  
Old 24-11-2009
Member
 
Join Date: Mar 2009
Posts: 1,584
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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Insert data from an Excel file into MySQL."
Thread Thread Starter Forum Replies Last Post
How to insert common data from on Excel File to another Rish!On MS Office Support 2 17-02-2012 02:10 PM
How to insert the corresponding data into multiple worksheets from a range of data in Excel ZaidaB Windows Software 2 22-01-2012 11:59 AM
How to Insert data into MySQL table Mahendra varma Software Development 4 04-10-2009 05:42 AM
Insert Excel data into Word Rivita Windows Software 2 24-09-2009 03:09 PM
export data in the bd Mysql to the Excel file Actionguy Software Development 6 02-03-2009 07:23 PM


All times are GMT +5.5. The time now is 10:39 PM.