Import excel data into mysql database
Solved/Closed
Related:
- Import excel data into mysql database
- How to import excel data to another excel sheet - Guide
- Possible to import pdf data onlin into excel? ✓ - Forum - PDF
- Import webpage data into Excel spreadsheet ✓ - Forum - Excel
- Excel data validation list multiple columns - Guide
- Multiple if statements in excel data validation ✓ - Forum - Excel
1 reply
rizvisa1
Mar 12, 2010 at 02:48 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Mar 12, 2010 at 02:48 PM
You can open a connection to excel and then read from the recordset would be one way.
Apr 10, 2010 at 08:39 PM
Apr 10, 2010 at 08:53 PM
Jan 5, 2011 at 03:41 AM
LOAD DATA LOCAL INFILE 'C:\\wamp\\tmp\\php89.tmp' INTO TABLE 'collection' FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'# Affected rows: 2599