CODEWITHSUNDEEP
phpsqldatabaseimportphpmyadmin
Deadlock
Deadlock

Reputation: 1577

Auto Import Excel into phpmyadmin

I want to import excel sheet into database through a web page.

For example- Admin can import the excel sheet into database like uploading a simple file.

I have searched throughout the stack overflow but unable to find any solution.

Please suggest some solution.

Upvotes: 4

Views: 2569

Answers (2)

Tim
Tim

Reputation: 2697

Export your spreadsheet as a CSV format and use the phpMyAdmin "Import" tab to import this file. You will need to match up the columns in your spreadsheet to the fields in the database table.

Upvotes: 0

user1581106
user1581106

Reputation:

The possible solutions are:

  1. Convert your excel file into CSV format. You can easily parse this Comma separated ASCII file using any server side scripting language such as PHP, JSP etc. and prepare appropriate queries to insert these fileds in the database.

  2. If you dont want to convert the Excel file to CSV then u need to use some APIs like Apache POI and Java Servlet/JSP programming clubbed with JDBC to put your data in the database.

Upvotes: 2

Related Questions