need sql query to import from excel sheet

[shoney33]

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 %.

[Rob Hecker2]

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/

[shoney33]

Thanks Rob,

     any query which can inert from excel file.

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

[Rob Hecker2]

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