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,487
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,831
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,098
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,591
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 01: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 10:59 AM
How to Insert data into MySQL table Mahendra varma Software Development 4 04-10-2009 04:42 AM
Insert Excel data into Word Rivita Windows Software 2 24-09-2009 02:09 PM
export data in the bd Mysql to the Excel file Actionguy Software Development 6 02-03-2009 06:23 PM


All times are GMT +5.5. The time now is 11:46 AM.