Copy link to clipboard
Copied
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 %.
Copy link to clipboard
Copied
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:
Copy link to clipboard
Copied
Thanks Rob,
any query which can inert from excel file.
something like insert into tablename value (excel file name or path name)
Copy link to clipboard
Copied
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:
Get ready! An upgraded Adobe Community experience is coming in January.
Learn more