Experts,
I am very new to SQL server. I downlaoded sql express in my desktop and wrote some a query that simply download an excel file from my hard drive to SQL server database. The query run good in management
studio.
question, can you tell, if it is possible to automate this process ( from excel to database ) by writing a script that connects to the database, and running my query on the background.
In other words, I wanted a user to simply click an icon on the desktop ( same desktop where sql server is loaded ), which should my query.
Is that possible?. If so, please let me know how I can do that.
Thank you
Dada400
Go to the complete details ...