Find Jobs
Hire Freelancers

Retrieve data from Excel file then connect to website SQL database and push updated data into 4 tables

$30-250 USD

Completed
Posted over 3 years ago

$30-250 USD

Paid on delivery
Hi there, I'm looking for someone to set up PHP on my office PC and create a PHP script that runs every X minutes (probably X = 5) , connects to my website's SQL server with a given IP and credentials, and pushes only data that has been updated in the last X minutes. The data source on the office PC is 2 Excel files consisting of 5 spreadsheets. On the website, Table 1 has 20 fields, Table 2 has 2 fields, Table 3 has 4 fields, Table 4 has 5 fields. Thank you. - jt
Project ID: 27463715

About the project

27 proposals
Remote project
Active 4 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
Awarded to:
User Avatar
Hello, Is the database in ms sql server or MySQL? As you will run the program in local computer in schedule, i think php would not be the right choice. If you prefer, i can develop a program based on .Net. Let's discuss more in detail. Thanks
$140 USD in 3 days
5.0 (344 reviews)
7.8
7.8
27 freelancers are bidding on average $172 USD for this job
User Avatar
Hi i can Retrieve data from Excel file then connect to website SQL database and push updated data into 4 tables i am good at Php , Excel , SQL , MySql so lets do talk more about it Thanks
$140 USD in 7 days
4.7 (538 reviews)
8.5
8.5
User Avatar
Hi, I am interested in your project and like to handle it. But I have question about the project. Why you like to use PHP scripts while you can have it as windows desktop application or as windows service that work in the background.
$444 USD in 7 days
5.0 (60 reviews)
7.7
7.7
User Avatar
Hi, How are you? I have developed several Excel & Word VBA macros before. And I know about Excel formulas very well. If needed, I first can do a demo and send it asap. And then you can see it and decide on this project. Also, I can send some of my VBA apps. I can complete your job successfully in your mind. Wishing for your response. Let me try at your job. Thanks
$140 USD in 1 day
4.9 (105 reviews)
6.1
6.1
User Avatar
hello , Sir? I have read your proposal very carefully. I'm very confident in the project, so I can get this done within 24 hours. I'm looking forward to working on your project Hope your kind contact. Thanks
$90 USD in 1 day
5.0 (23 reviews)
5.8
5.8
User Avatar
Hello, I am a powershell and php expert, Could you please confirm you are only looking solution from PHP or you are good with Powershell? if you are ok with Powershell i can quickly provide the solution because i did similar project before Or still you are looking for only PHP still i can able to help Kindly ping me further discussion Thanks
$200 USD in 7 days
5.0 (66 reviews)
6.0
6.0
User Avatar
Okay sir, I will automate it all. I will install PHP on your Offic PC and then I will set it up all to retrieve data from Excel frok your pc for X minutes and then pushes data to yours MySQL server . Please let me know sir, when you here . thank you.
$160 USD in 4 days
5.0 (39 reviews)
5.5
5.5
User Avatar
-- i can give you a desktop tool, which perfectly work for you that you have expected. I have ready tool, just mapping your website table and your excel. thank you
$135 USD in 2 days
4.9 (38 reviews)
5.7
5.7
User Avatar
Dear Client, I am glad to inform you that I can create PHP script to upload Excel data in tables. Let's discuss more in details to tell you exact cost. I have 10+ years of experience in technologies like PHP, HTML, CSS, Wordpress, Codeigniter, Prestashop, Mysql, .NET, MVC etc. I assure you that you will always get a quality work from here. You can read my reviews from previous employers before hire me. I am dedicated toward my work. Thanks
$200 USD in 7 days
5.0 (46 reviews)
5.2
5.2
User Avatar
should be a cinch as i have already been doing syncing job on daily basis between csv (can do xls as well) and mySQL server using php. kindly let me know if you consider me
$70 USD in 1 day
4.9 (96 reviews)
5.4
5.4
User Avatar
Hello How are you? I checked your description "Retrieve data from Excel file then connect to website SQL database and push updated data into 4 tables". I'm a senior PHP developer with 9 years of experience. I will deliver you great result asap. If you check my portfolio, you will know my skills surely and will be satisfied with my work. please contact me and let's discuss more in detail. thanks
$120 USD in 3 days
4.4 (23 reviews)
5.5
5.5
User Avatar
Hi There, I can build solution using .net technology and it will fetch data by specified interval and update to SQL Server database. Looking forward to discuss. Thanks
$250 USD in 10 days
4.8 (7 reviews)
4.3
4.3
User Avatar
Hi, I have 5 years of experience in programing. Developing for desktop, web and mobile. I would recommend a small tray type of application, as PHP needs to be called to execute. I can make the small application to watch the file for modifications and upload data from it if detected.
$150 USD in 7 days
4.9 (13 reviews)
3.0
3.0
User Avatar
Hi, I can do this using PHP or VBA(Best suitable) to do this and schedule as per your needs. Please share the details to proceed. Thanks, Sunith
$140 USD in 7 days
5.0 (2 reviews)
2.3
2.3
User Avatar
Hello, my name is Umer. I am a specialist of data entry and have worked in data entry for five years now. I have experience with several different kinds of data entry work including medical, pharmaceutical, educational, and other general categories. I work very well with Microsoft Word and Excel, as well as other data programs. I am well acquainted with administrative tasks and can identify errors and deficiencies in data as well as get them correct quickly and efficiently. I'm available to work on your project ASAP, If you are interested please don't hesitate to contact me Thanks in advance for your consideration Umer
$100 USD in 4 days
5.0 (3 reviews)
1.8
1.8
User Avatar
we have dedicated developers with more than 3+ years of experience who can handle this for you. We have worked on more than 150+ projects till now that include Websites, Web Apps, Mobile Apps, etc. We always focus on strong and long-term relationships so there are no issues of the budget as well. Hoping to discuss more in chat.
$120 USD in 7 days
3.8 (2 reviews)
2.0
2.0
User Avatar
✔️PHP ✔️Javascript ✔️CSS Hello. I'm full-stack developer with skills including PHP, Javascript, typescript, CSS. I have +5 years experience with PHP. I'm new here. So I have one review. But that doesn't mean I'm new programmer. If you trust me, I will give you a good result. And I will work for you full time. Thank you for reviewing my bid.
$250 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
You could install xamp or another server for pc that allows the execution of PHP code,, A script that captures the data from a sql database (not defined yet) is made and will be exported to an excel file.
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED ARAB EMIRATES
Dubai, United Arab Emirates
5.0
12
Payment method verified
Member since Oct 4, 2012

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.