I have database and excel file ready. currently I am manually copy pasting data from SQL Table to Excel file once in a day daily and then refreshing pivot table. I have tried linking sql database with excel using connection but when I open excel on other systems where DB is not connected it gives error and it always take time to refresh the connection.
SO my requirement would be.
I need a script which I can run with task scheduler once in a day to copy paste data from my sql database table to excel file existing sheet and save it. when I open excel file there should not be any connection between database and excel so it will open as normal. Pivot table should refresh once data is populated to my excel file once.
13 freelanceria on tarjonnut keskimäärin ₹1250 tähän työhön
I will write an ETL that you will run daily and update the file. The excel file will load as normal, ofcourse. I look forward to hearing from you. Regards,
Hi! I have good experience in MS Excel, VBA and also MS SQL Server. I will like to work on this project, please consider. Looking forward to work with you. Thanks, Qaisar