Find Jobs
Hire Freelancers

Create Microsoft SQL database

$750-1500 USD

Closed
Posted over 9 years ago

$750-1500 USD

Paid on delivery
Create a Microsoft SQL database using: 1. Multiple tables in Access & Excel 2. Perform simple functions like additions, count & look-ups 3. Automate the table update when the source tables are updated Link the final table to excel pivot for further analysis (the excel piece already completed) The dataset is likely to be about 2 million rows & 100 columns.
Project ID: 6311671

About the project

79 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
79 freelancers are bidding on average $1,100 USD for this job
User Avatar
Hello, I am very much interested to do this job as i am experienced a lot in ms sql server related works and i also worked on many excel & access related jobs. I think i am the right person for this project. If you want i can develop an application in .Net or can develop excel/access macro to fulfill your requirements. Let me know your choice. Looking forward to have a positive response from you. Thanks
$750 USD in 14 days
5.0 (302 reviews)
8.1
8.1
User Avatar
Hello, I am having vast experience in Software Development and have special command on Microsoft Technologies. My 12 years of experience makes me most suitable for this job. Regards
$842 USD in 30 days
4.9 (15 reviews)
7.6
7.6
User Avatar
Hi, I've extensive experience developing risk monitoring spreadsheets and databases within the investment banking industry (which aggregated vast amounts of financial data). I also have two postgraduate qualifications which are invaluable. Please have a look at the Portfolio section of my Profile in Freelancer for screenshots of recent Access databases I've constructed - the most recent is going to be distributed commercially in the US within the insurance industry (clicking on my username Systems3000 should take you to my Profile where you can see the Portfolio tab). I've also got a lot of experience with Excel - importing/exporting between Access and Excel (and SQL server) is very straightforward and there are performance improvements that can be implemented to speed up the processing of 2 million rows and many columns. I specialise in ensuring that the Access applications I develop are first class Window applications (rather than mere databases) - with robust processing, precise and thorough business logic, and professional user interfaces that ensure ease of use, quality of data, and good integration with other systems, including Excel. Please let me know if I can be of assistance.
$750 USD in 6 days
5.0 (221 reviews)
7.6
7.6
User Avatar
Hi there. I have done table creation in SQL using Access and Excel tables and I can handle your project with comfort and ease. Kindly discuss details if you would like to continue with me. Usman.
$1,100 USD in 6 days
5.0 (77 reviews)
7.0
7.0
User Avatar
A proposal has not yet been provided
$1,546 USD in 20 days
4.9 (2 reviews)
6.6
6.6
User Avatar
I have 15 years experience in access database design and development. I have completed well over 250 custom databases in this time. I have worked on existing databases and created from scratch. A list of some databases I built are. ASCL database for Major Hospital in OKC. A scheduling program for the anesthesia department for a Major Hospital in OKC. A ford Parts Database to help a company keep track of inventory in house and EBay. and Many more. I was on Freelancer for 3 years and my account was hacked and I had to create a new profile. I have all my feedback from that site if you want to see them. Donna
$888 USD in 20 days
4.8 (44 reviews)
6.7
6.7
User Avatar
I have been in this industry for 6 years and such jobs are my daily practice. This is my first time on this site and hence you can see that I have only 4 ratings/feedback to show you. I can assure you that if you work with me once, you will always work with me for these kind of projects. I am able to handle such a big amount of data and can fulfill all requirements you described in Project description. You can see my profile to know more about me. Let's discuss for more details. Thank you in anticipation.
$1,000 USD in 10 days
5.0 (83 reviews)
6.3
6.3
User Avatar
Hi We will make a linked connection between sql server and the Access. The tables from access will be created automatically to SQL and any changes you will make to the access will be transferred to the SQL automatically. We will make a SSIS package to make the updates from your excel. Finally we will make all the appropriate Functions and SPs perhaps summarized tables and in general whatever it is necessary to improve the performance of your final excel. The size of the finally table does not matter. I could make a more precise estimation if i knew the number of the tables and the sheets from the excel that will be imported and manipulated for the final table. Currently I am working at big financial organization in which I Am responsible for the MIS. I have designed and Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2. The reports are being produced automatically on Excel , CSV or SSRS. The DataBase which has been designed and developed by me consists of 4500 objects, tables ,sp , views , etc. and is about 4 TB.
$1,000 USD in 15 days
5.0 (70 reviews)
6.3
6.3
User Avatar
I'm an expert solution provider with 18 years of experience. I have excellent exposure to the kind of skills you need, staying certified continuously over the years, and completely understand your requirements as well. Do let me know if we can discuss this further.
$1,184 USD in 20 days
4.7 (7 reviews)
6.7
6.7
User Avatar
Hi, Approach: Tool description: Organization: It has three parts: 1) Database (Access), which holds data 2) User Interface, to provide user input (in Excel) 3) Processor, which runs various programs like additions, count & look-ups Functionalities: 1) Addition 2) Vlookups 3) Data updation Tool language: It is based on Microsoft excel and uses VBA code for operation. I believe I can help in your work. Please have a look at reviews provided by previous employers. Please contact for further discussion. Regards! Vikas
$1,250 USD in 10 days
4.9 (38 reviews)
5.6
5.6
User Avatar
Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases BI, i have more than 8 years in IT projects with 5 years working around databases and BI development. My last job was senior BI consultant within Accenture ,for more than 4 years .I worked for several database projects and advanced SQL development on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I have strong skills in database and Business Intelligence to develop all types of requirements related ,and given my experience, I am persuaded to give you High quality of work delivery withing budget and time Best regards,
$1,111 USD in 16 days
4.9 (14 reviews)
5.2
5.2
User Avatar
Hi, please consider my bid on your project. It's the kind of task I routinely do in my day job and I'm confident I can deliver quickly for you. It's been a while since I did any Freelancer work but I'm trying to start up again so would appreciate this opportunity. Many thanks. Pete O'Connor
$1,250 USD in 3 days
5.0 (13 reviews)
5.0
5.0
User Avatar
Hello, I have more than 13 years of programming experience with Windows and Web Applications. I am well-versed with the Microsoft Technology. Proficient in programming with VB6, VB and C#.Net and different databases like SQL Server, Oracle, MySQL and MS-Access. Please check my tremendous 118 feedback to know more about my client's views for my work. Please also check my portfolio for some software designs for windows applications. Please initiate the discussion on freelancer or skype so we can move further for the work. Awaiting for your prompt response. Thanks, Dhirendra
$1,666 USD in 30 days
5.0 (23 reviews)
4.8
4.8
User Avatar
Hi, I have gone through your requirements .I am a DBA at CMMI-5 Level company since August 2010.I am working on Microsoft Access,MySql,SQL Server,Oracle database, I can do your job confidently. I am very much Interested to do your work,Please revert me if you have any concern .I am ready to start now.
$1,200 USD in 10 days
4.9 (8 reviews)
4.4
4.4
User Avatar
Hi, I am a telecom engineer, with many years of experience developing desktop applications using excel, access and SQL Server. I will deliver a nice application in C# that will serve you to add/delete/search, etc. in your SQL database, and that will export the result to excel as you want. Please send the current excel and access files, and I will give you back a demo with everything included. Kind Regards, Manuel
$750 USD in 30 days
5.0 (2 reviews)
4.0
4.0
User Avatar
Excel VBA connection to SQL Server Excel VBA connection to Access Lookup query Insert Delete Update
$750 USD in 10 days
4.9 (6 reviews)
3.9
3.9
User Avatar
I can create SQL Server database easily from MS Access and Excel tables. And write your required methods that you mentioned. I have done lot of work on database conversion so I can do it very easily and I also write lot of software/database scripts Technologies: I will use SQL Server 2008 Expertise: I have more then 7 years of industry experience of software/web/database development with 4 years of computer science educational background with Microsoft certifications. Thanks
$751 USD in 15 days
4.9 (29 reviews)
3.9
3.9
User Avatar
Dear Sir, We are the globalized software services organization specialized in providing Mobile, ECommerce and Social media frameworks using cutting edge and emerging technology. Leveraging best-in-class people, processes, and technologies, we provide high-quality software development and consulting services to independent software vendors and enterprises with WOW factor. We are specialized in providing solutions on the following areas: (1) Mobile application development (iPhone, Android, BB, Windows Mobile) (2) ECommerce Solutions (WordPress, Magento, OpenCart etc) (3) Windows application development (4) Web application development (Open Source, .NET, JAVA, PHP, node.js) (5) Cloud based solution (6) Image Editing (7) Casino Games development (8) Independent testing. I have gone through your requirements. We would like to discuss more on this project. Looking forward to hear from you. Thanks, Ankur Agrawal SuiGen Solutions
$1,181 USD in 23 days
4.9 (7 reviews)
3.6
3.6
User Avatar
Hello. More 20 years programming experience. I need more details to set real time and price. Regards. -----------------------------------------------------------------------------------------------------------------------------------------------
$750 USD in 10 days
5.0 (2 reviews)
3.2
3.2
User Avatar
Hi, I'm very interested helping you creating your database, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to check my portfolio, there is some samples of databases modeling and database assignments. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. Please send me all other details if you have about your database project, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
$1,000 USD in 10 days
3.5 (7 reviews)
4.2
4.2

About the client

Flag of HONG KONG
Hong Kong
0.0
0
Member since Aug 12, 2014

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.