Find Jobs
Hire Freelancers

SQL/VBA project upgrade - open to bidding

€8-30 EUR

Closed
Posted about 10 years ago

€8-30 EUR

Paid on delivery
Hi, I saw that you bid for a previous project. I see your skills also include MSSQL and C#. For the specific project I am offering you, understanding of MSSQL and VBA/Excel will be required. We have a functioning code/system that 1) uploader: uploads CSV data to SQL via an executable 2) graphingmodule: downloads specific data and symbols from the SQL through Excel What we need is: 1) uploading is ridiculously slow. We need to see if we can get significantly speed that up. 2) interactions between excel and SQL seem slow. Need to see if we can significantly speed this up. 2) add a few variables to the downloader specifically: A) a symbol balance counter of a composite (will explain in more detail later, this is based on some simple math with the data requested from SQL) B) add variable for symbols in symboldata tab and SQL: composite weight C) use this weight to calculate an added variable on symboldata tab. Please quote me for this project. I´ve attached the source code for uploader and downloader. I think there´s a stored procedure involved here as well but this should be a straightforward structure
Project ID: 5575117

About the project

4 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
4 freelancers are bidding on average €62 EUR for this job
User Avatar
Hi rdmusic, After reading your instructions, the slow response is because of ODBC connection established between Excel and SQL. When you say SQL is it Microsoft SQL or MYSQL ? When you establish connection between SQL and Excel there are several factors to monitor by which you can maximise the transfer of data from SQL to Excel. I do not see any code attached to project description Please provide code so that i can have a look. -Naveen MS SQL and VBA Expert
€24 EUR in 1 day
4.8 (24 reviews)
4.6
4.6
User Avatar
I am available right now. In my total 13 IT years of experience I have done lots of with project management.I am a expert Database Architect.I have done lots of database design and development for desktop and web based applications using .Net, LAMP, Flash Action Script, HTML 5, Java Script, JQuery, AJAX, CSS, XML,DNS, IIS(Admin),Oracle PL-SQL,Classic ASP, MS SQL (DBA,T-SQL),VB 6.0,VBA,COM/DCOM,VB Script,MS Access, Excel, Macros, Flash (AS2, AS3), Crystal Reports (Designer and Server), ColdFusion
€166 EUR in 3 days
5.0 (4 reviews)
3.1
3.1

About the client

Flag of UNITED STATES
Morristown, United States
0.0
3
Payment method verified
Member since May 25, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.