Tag Archives: mysql

How to connect ms excel-2007 with mysql.

Questions: How to connect excel-2007 with mysql. I am on windows 7, 64 bit. Using excel-2007 32 bit and mysql version 5.1 , 32 bit. Can Anyone help me how to import my mysql table data in excel file. Thanks in advance. Answers: I am adding to @Anil Chahal answer: After configuration as described by… Read More »

PHP to MySql to CSV to Excel UTF-8

Questions: I know this has been discussed several times but yet I’m getting crazy dealing with this problem. I have a form with a submit.php action. At first I didn’t change anything about the charsets, I didn’t use any utf8 header information.. The result was that I could read all the ä,ö,ü etc correctly inside… Read More »

Upload a .csv file into PHP MySQL database without column headings

Questions: I want to upload .csv files into MySQL database using PHP. I have this code: <?php include_once ‘db.php’; if(isset($_POST[‘submit’])){ if($_FILES[‘csv_data’][‘name’]){ $arrFileName = explode(‘.’,$_FILES[‘csv_data’][‘name’]); if($arrFileName[1] == ‘csv’){ $handle = fopen($_FILES[‘csv_data’][‘tmp_name’], “r”); while (($data = fgetcsv($handle, 1000, “,”)) !== FALSE) { $item1 = mysqli_real_escape_string($dbConnection,$data[0]); $item2 = mysqli_real_escape_string($dbConnection,$data[1]); $import=”INSERT into tbl_csv values(”,’$item1′,’$item2′)”; mysqli_query($dbConnection,$import); } fclose($handle); print “Import… Read More »

Only 1 column is added to my MySQLDB from Excel File

Questions: I am trying to insert data from Excel file to Mysql DB. It works but the problem is, it insert just 1 column. I need to insert all the column from my Excel file Here is my Code protected void add_Click(object sender, EventArgs e) { if (importfile.HasFile) { string path = string.Concat((Server.MapPath(“~/temp/” + importfile.FileName)));… Read More »

mysql for excel

Questions: I am not sure if this is the right place to ask this question but I am facing an issue with MySQL installed failing to recognize office 2013 and install MySQL for Excel. Basically MySQL https://dev.mysql.com/downloads/ Has an addin for excel that allows you to automatically connect to a database and make changes. During… Read More »

How to save the excel file data into mysql database table as a record by record using apache POI

Questions: I am not able to store excel file information into a database table. Can any one help me how to save a file data into a table which have different datatypes like bigint, varchar and date.Here I am providing my programe on saving excel file into database record by record? import java.io.*; import org.apache.poi.hssf.usermodel.HSSFWorkbook;… Read More »