need sql query to import from excel sheet

Forum|Forum|11 years ago
December 16, 2014
1 reply
601 views

Hey , i need sql query to import from excel sheet.

i work in a company where i need to daily update the data from excel sheet.

if i get a shortcut method i ill be very thank full to you guys to reduce my work upto 10 %.

This topic has been closed for replies.

Rob Hecker2

Legend

You can do this with a plug-in from dev.mysql.com called "Mysql for Excel," which allows you to import data from Excel to MySql as well as from MySql to Excel. Here is the download link:

http://dev.mysql.com/downloads/windows/excel/

shoney33Author

Participating Frequently

Thanks Rob,

any query which can inert from excel file.

something like insert into tablename value (excel file name or path name)

Rob Hecker2

Legend

any query which can inert from excel file?

Sort of. Certainly not anything as simple as what you seem to hope for. Check out this very good PHP class:

PHPExcel - Home

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded