Import a file more of 60000 records in a MySQL database: I need to import dbf file or Excel file

Recommend this page to a friend!

All requests

Import a file more of 60000 records i...

Request new recommendation

Featured requests

No recommendations

Import a file more of 60000 records in a MySQL database #import data

Edit

by sheyda - 10 years ago (2015-06-24)

I need to import dbf file or Excel file

+3	I need to search in my SQL database, so I need to import a file with more than 60000 records.

1 Clarification request
1. by Dave Smith - 10 years ago (2015-06-24) Reply
are you able to produce a file in .csv (comma separated values) format?

If not, then you will need 2 classes. One to convert the excel file to .csv and another to import the csv data into the mysql database.

I was not able to locate a single class on here that does both.

If memory allocated to PHP on the server is an issue, then you will need a class that uses generators to read the file.

2. by sheyda - 10 years ago (2015-06-27) in reply to comment 1 by Dave Smith Comment
Can you say the name of the class?
3. by Manuel Lemos - 10 years ago (2015-06-27) in reply to comment 2 by sheyda Comment
Dave suggested that you use two classes: one to convert the Excel file to .csv and another to import the csv data into the MySQL database. Which one do you need more?

Ask clarification

1 Recommendation

dbf2mysql: Import data from DBF files into MySQL databases

This class can be used to import data from DBF files into MySQL databases.

It uses the dbase extension functions to open and retrieve data from DBF files.

The class generates a string with SQL statements to create tables in a MySQL database and insert rows with the data from the DBF files.

The generated SQL statements maybe displayed in a HTML page, served for download, or stored in a file.

The code and comments are in Spanish.