Kapalı

Reports Automation in Excel And SQL

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.

Beceriler: Microsoft Access, SQL, Microsoft SQL Server, Visual Basic, Excel

About the Client:
( 0 değerlendirme ) South delhi, India

Proje NO: #32604602

Bu iş için 13 freelancer ortalamada ₹1008/saat teklif veriyor

fastlabindia

Greetings!. I checked your Database Design requirements. Your work is one of the tasks that can be done very perfectly by us. I am good in MySQL , MS ACCESS, MS SQL, Oracle , No SQL and other DBMS software, Queries, Re Daha Fazla

₹750 INR / saat tutarından itibaren
(13 Değerlendirme)
4.6
teekayzitsi

Hi In my current Profession -I perfom the DBA and Developer duties in high traffic OLTP environment -Python programing,-Data Scraping using python,data analysis using python and R -Database development in (Mysql,Po Daha Fazla

₹1000 INR / saat tutarından itibaren
(6 Değerlendirme)
3.8
(11 Değerlendirme)
4.3
anandan1995

I have a experience in asp.net, MVC, web API,Laravel,Php,,Java, Spring mvc,Hibernate, c#, SQL, entity framework,linq, razor view (Cshtl), html, Wordpress,Joomla,Shopify,Jstl,bootstrap,Angular JS, Jquery, Json,XML, repo Daha Fazla

₹750 INR / saat tutarından itibaren
(15 Değerlendirme)
3.5
bizmanas

Hi I have 15 years of experience in SQL server Database development. I will be able to help you with the project. please ping me offline to discuss further. I have extensive experience in SQL query tuning.

₹2000 INR / saat tutarından itibaren
(7 Değerlendirme)
2.9
dskapkoti111

i can do any thing . i can do this work very fast. you can believe to me . and i can type any type hindi and english and do any typing work.

₹1000 INR / saat tutarından itibaren
(0 Değerlendirme)
0.0
SURENDRA77KUMAR

Completed engineering and in that 4year mostly hands on the keyboard, can easily retype your pdf doesn't matter how long your data and make changes as per your requirement, and make sure your data will completely safe. Daha Fazla

₹1000 INR / saat tutarından itibaren
(0 Değerlendirme)
0.0
saisureshsanapa7

I am well experienced in SQL database.I have worked many projects with SQL database.I have good knowledge in it.I can handle this project with ease.

₹750 INR / saat tutarından itibaren
(0 Değerlendirme)
0.0
sujitkumarram199

I saure this work it ihis very good data entry always high speed at data [login to view URL] a liberty this final safe work .

₹1000 INR / saat tutarından itibaren
(0 Değerlendirme)
0.0
RichaRai0809

My efficiency is very good in typing with well written spelling and without grammatical error, will deliver your project on time. Your project will be delivered on time.

₹1000 INR / saat tutarından itibaren
(0 Değerlendirme)
0.0
hp874754

I'll give all my time in this project. Only full concentrate on this. I'll do Anything for this project. And i m sure i'll complete your holl project.

₹1000 INR / saat tutarından itibaren
(0 Değerlendirme)
0.0
Sairahul099

I worked as big data developer for data lake in SQL and python tools. I am expert in SQL and automation in pytho which will be perfect fit for this role

₹750 INR / saat tutarından itibaren
(0 Değerlendirme)
0.0
preitymathur0422

Innovative and technically-astute software developer with 13+ years of experience in developing full stack applications. I am confident enough to do justice to your task and complete the task timely and fulfill the exp Daha Fazla

₹1100 INR / saat tutarından itibaren
(0 Değerlendirme)
0.0