473,383 Members | 1,872 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

how to insert data in mysql table directly from excel sheet?

i dont want to use spreadsheet::parse module?i want to insert bulk data directly to mysql table in bulk
Feb 19 '14 #1
2 1338
how to convert accdb file to mdb file format..........
Feb 19 '14 #2
RonB
589 Expert Mod 512MB
Save the spreadsheet as a csv file then use the mysql "LOAD DATA INFILE" statement to import it into the db.
Feb 19 '14 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Martin | last post by:
There is an Access table on the network. 15 users who do not have Access are connected to the network. Is there a way for each user to be able to enter one or more rows containing 3 or 4 columns to...
3
by: Mamatha | last post by:
I have one table in Excel database and i want to insert a new row to that table.I don't have that much of knowledge to insert a new row into that table through VB.NET.If any one can know,Please...
1
by: Mamatha | last post by:
Hi I want to export data from textfile to Excel sheet in VB.NET application.When i copy the text file into Excel sheet the data of text file are copied to only one cell of the Sheet. Now i...
1
by: friendlyrohit | last post by:
Hi All !!! Can anybody help me out, how to retrieve a desired column's data from an existing excel sheet through the vb code....... Dim strData As String Dim ts As TextStream ...
5
by: Rishika14 | last post by:
Hi, Somebody pls tell me how to export data from webpage to excel sheet using java script. rishika
4
by: sandeep123456 | last post by:
hi, can we send data from html to excel sheet using java script sandeep
3
by: imtmub | last post by:
Hi, I am trying to link sql table field and excel sheet column. SELECT wko_itemid, imc_qty, ima_price FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel...
1
by: runway27 | last post by:
1. I need to export data that is in a table to an excel sheet with the field names on top followed by the values of the fields. I know how to extract the data and display with echo statement,...
6
by: gmujjain4902 | last post by:
Hi, Please help me with code for to Export HTML table to Excel sheet using javascript without using ActiveX controls... The problem is i could get solution for my problem via ActiveX control...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.