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 RSS feed  >  Import a file more of 60000 records i...  >  Request new recommendation  >  A request is featured when there is no good recommended package on the site when it is posted. Featured requests  >  No recommendations No recommendations  

Import a file more of 60000 records in a MySQL database

Edit

Picture of sheyda by sheyda - 5 years ago (2015-06-24)

I need to import dbf file or Excel file

This request is clear and relevant.
This request is not clear or is not relevant.

+2

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

  • 1 Clarification request
  • 1. Picture of Dave Smith by Dave Smith - 5 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. Picture of sheyda by sheyda - 5 years ago (2015-06-27) in reply to comment 1 by Dave Smith Comment

      Can you say the name of the class?

    • 3. Picture of Manuel Lemos by Manuel Lemos - 5 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 recommendation solves the problem.
This recommendation does not solve the problem.

0

Picture of Manuel Lemos by Manuel Lemos Reputation 20680 - 5 years ago (2016-04-19) Comment

If you have your data in DBF format, this class can convert it to MySQL.


Recommend package
: 
: 
For more information send a message to info at phpclasses dot org.