Find Jobs
Hire Freelancers

Automated SQL database import

£20-250 GBP

Closed
Posted almost 6 years ago

£20-250 GBP

Paid on delivery
Hi. I get daily reports in .xls format that I need to import into a SQL database, the daily report then needs moving from the folder into an archive folder. It needs to run automatically in the background
Project ID: 17033304

About the project

23 proposals
Remote project
Active 6 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
23 freelancers are bidding on average £150 GBP for this job
User Avatar
Hi! I'm interesting your project very well. I am mastering excel and sql. And also I have many experience and good skill about web development. Let's go ahead with me
£150 GBP in 3 days
4.9 (7 reviews)
4.5
4.5
User Avatar
I am very proficient in java. I have 16 years java developing experience now, and have worked for more than 7 years. My work is online game developing, and mainly focus on server side, using java under Linux environment. I made many great projects using java, for example, I made the tools which could convert java files into c++ scripts, of course garbage collection included, this job was very similar to a compiler, and was very complex. I also made our own mobile game using java, I can show you the demo of client, if you like. I have a very good review on Freelancer.com, I never miss a project once I accept the job, you can check my review. Trust me, please let expert help you. Besides, I am very proficient in c++ also, hope I can help you.
£120 GBP in 3 days
4.9 (9 reviews)
4.5
4.5
User Avatar
Hello, I read your project brief. Can you please tell me how do you get your daily reports in XLS format? I assume you get them via email. Anyways, I can develop a program for you in PHP which allows you to extract information out of your daily XLS reports and insert them in SQL database. You also didn't mention which SQL database do you use but I assume it's MySQL. I can also program for other SQL databases too if in case you're not using MySQL. If you're on a Windows machine then you can setup a task in Task Scheduler to run this PHP program daily to process your reports and insert their content in SQL database. I can help you setup a task in Task Scheduler if in case you don't know how to do it. About Me ======== I'm a PHP developer having experience in modern web technologies including HTML, CSS, JavaScript, XML, JSON, MySQL and PHP. I also have experience in building command-line tools and utilities in PHP including web scrapers, web crawlers, and webbots.
£100 GBP in 5 days
5.0 (1 review)
2.6
2.6
User Avatar
Hi there, I am java developer. This is an easy job for me. I will make a tool that will run on background and do this job easily. Have a look at my profile for my portfolio and past work experience here. Message me, we can discuss over chat.
£120 GBP in 3 days
4.6 (3 reviews)
2.9
2.9
User Avatar
Price for discuss. Hi, nice to meet you, i have developed before an automated script for getting XLS values and insert it into a database, if you need that work be automated i can put it with a script or setting a cron job if you like, this job is fast to develop and only took few hours to be completed, my skills are strong for do that with many programming languages and web services, please let me know if you like this job done. We can discuss the price too ;)
£100 GBP in 1 day
5.0 (1 review)
1.9
1.9
User Avatar
Dear Phild123, I am very interested for this Automated excel to mysql database project. I have 8+ Year of Experience in this field and I can surely do this project , i work with my team who always looking for such type of project . so please sir try to give me one chance to prove my strength and quality of work. Actually sir money is not a matter i only want to do this project if you feel good with my work then only after you can award me and pay for this project , me and my experienced team believe in accuracy and quality of work. Trust me sir i never disappoint you at least you can give me one chance. Please check my profile in freelancer.com https://www.freelancer.com/u/mdubey.html Please message me on PM for further discussion. Thanks & Regards Mohit
£90 GBP in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Dear Sir, Please share me more information about your database, This project is easy to be done, but you must determine your database type.
£55 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi - I have done such projects many times and there are simple utilities with which we can achieve this. Once done archival can be done. We can write a simple excel macro/power shell program that can perform all these activities.
£150 GBP in 3 days
5.0 (1 review)
0.0
0.0
User Avatar
Hi, I'm a DWH/ETL/BI expert from Bulgaria (EU) with 9+ years of experience in that field. I'm proficient in wide variety of data tools: 1.ETL-SSIS, Pentaho Kettle, Talend, Oracle Data Integrator (ODI), Informatica. 2.Databases-MySQL, MSSQL, PostgreSQL, Oracle, Teradata and a few others. 3.BI-Pentaho BI, SSAS, SSRS, PowerBI, Cognos Also, my daily job routine requires very good scripting skills: Bash, Powershell, Python, as well as deep knowledge of SQL and database performance tuning and optimization. Best Regards, Veselin Z.
£250 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, before accepting, please read: is it an 2013 xlxs-sheet? are the headers defined? would a scheduled task be a sufficient solution for you?
£88 GBP in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Import .xls files into a SQL database, moving the daily report into an archive folder. Application to run automatically in the background.
£100 GBP in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I'm a software developer with over twenty years of experience in academic, scientific and commercial organizations. Although I'm new to this site, I have been working on a freelance basis for the last 5 years mainly managing and developing a suite of excel utilities for a client in the uk. Your requirement sounds fairly typical of the sort of thing I've been working on. From the small amount of detail you've given, I would suggest a simple vb.net application or console application running as a daily scheduled task would do the trick. I've budgeted for basically a days work. Please don't hesitate to get in touch if you would like to discuss it further. Best regards Alistair
£222 GBP in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey hi. Let’s have a round of discussion and we are good to go for this. Looking forward to contact you soon.
£222 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Hiring Manager, Last 4years I have been working on Pega Robotic Automation, ASP.NET, SQL Server, IIS Server, JavaScript, HTML5, CSS, Adobe Photoshop. I like programming and feel that there is nothing I can do. It is pleasure for me to use all my knowledge and learn more in programming field. I have experience from developing business needed web sites. Also, I have a very good experience in RPA/RDA with Pega Robotic Automation. I have worked on different automations with different stockholders. My favorite language is C#, but I also use VB.Net and Pega Robotic Automation for automation projects. I worked with almost all DBMS from SQL to Oracle, from single server DB to cloud and distributed customized shards. If this is project real requires so many skills, let me join it and lead it to success. My regular rate is $15/h and I will be available to work with you at-least 30 hours per week as a full-time basis. If you think that the rate is too high, let me know and to discuss it - I am sure that I can explain why or find a compromise. Looking forward to hear from you, sir. Thank you for your consideration. Best Regards, Sajid Ali Abbasi Software Engineer (.NET/Pega Robotic Automation Developer)
£555 GBP in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
for this case a job is created where a procedure makes the import of the xls file into a table, using openrowset
£55 GBP in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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. I also have plenty of experience using the MS Office suite, specially MS Excel. I can help you with your requirement, using a SSIS package. We can discuss further details over chat.
£140 GBP in 2 days
0.0 (0 reviews)
2.4
2.4
User Avatar
Hi, I'm an experienced programmer. I've done many similar tasks before. I would do this as a C# .Net desktop application. However it is crucial to know both xls and sql srtuctures and needed additional operation during migrating data. So my offer may change after I know all details. Regards
£150 GBP in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
United Kingdom
0.0
0
Member since May 24, 2018

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.