Hello! I am a Computer Engineer, with a Master of Business Administration and a MCSA SQL Server 2014, with more than 10 years of experience using SQL, queries, reports and dashboards design and construction, data warehousing, and overall Business Intelligence related projects and tasks. I am a near-native English speaker, currently available, and results oriented - I am a freelancer, which requires little to none supervision to deliver.
My strongest skill is SQL Server, and also have Azure as one of my top skills.
I have done file import from flatfiles and Excel files to Azure before. I can help you with your request.
My approach would be the following:
- Create a Blob in Azure and upload the Excel file
- Program a refresh (using PowerShell) to upload the file periodically (nightly?) to the Azure Blob
- Make a Stored Procedure that reads the Excel/CSV file from the Azure Blob. Here we can use BULK INSERT or OPENROWSET methods and inserts/updates the data in its respective tables.
- Schedule the execution of the Procedure.
About the schedule; the file upload(refresh), the read from table and the insert/update can be programmed in Azure in one only schedule, with the needed periodicity.