Reports Automation in Excel And SQL

Job ID: 32604602

Budget: ₹750 – ₹1,250 INR

Without going into great detail about the actual code involved, I'll outline the steps required to create the recordset we need to build our Excel spreadsheet.
Collect SQL Server Login Parameters (Server, Database, UID and PWD)
Get the path to the .sql file with the Query SQL
Validate existence of both the file and the SQL Server
Use VBA to extract the text from your saved query .sql file.
Create a Microsoft Access SQL Passthrough Query
Set Query's Connect String, SQL, Timeout and Return Records properties
Flag any DELETE and UPDATE queries. (Dissallow or run with password only)
Execute the Access Passthrough Query into a DAO Recordset object.