Completed

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

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

Skills: PHP, MySQL, Excel, Software Architecture, SQL

See more: import data from excel to sql server using query, vba code to import data from excel to sql server, import data from excel to azure sql database, how to export data from sql server to excel using query, inserting data from excel to sql table using query, how to import data from excel to sql server, import data from excel to sql server automatically, sql select * from excel sheet, making website sql database, connect website product database, file upload php sql database, generate static website sql database, moving website sql database, binary file uploading aspnet sql database, clone website sql database, excel visual basic retrieve excel file, insert file content microsoft sql database, registration form php connect form sql database, connect access sql database, joomla website sql database

About the Employer:
( 11 reviews ) Dubai, United Arab Emirates

Project ID: #27463715

Awarded to:

sumon355

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 discu More

$140 USD in 3 days
(336 Reviews)
7.7

30 freelancers are bidding on average $166 for this job

(165 Reviews)
8.2
gopalvora

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
(538 Reviews)
8.4
esalem

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 More

$444 USD in 7 days
(55 Reviews)
7.6
(554 Reviews)
7.7
ykarora26

Hello sir, I already gone through the all information or description which is detailed by you. You are looking for Retrieve data from Excel file then connect to website SQL database and push updated data into 4 tables More

$160 USD in 7 days
(255 Reviews)
7.4
(104 Reviews)
7.3
(178 Reviews)
7.0
(51 Reviews)
6.2
goodwork20k

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 s More

$200 USD in 7 days
(55 Reviews)
5.8
Shendiqerimi

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
(23 Reviews)
5.8
akritisood94

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 More

$140 USD in 1 day
(72 Reviews)
5.6
tutulsoft

-- 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
(29 Reviews)
5.5
turaab

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
(96 Reviews)
5.4
scriptzguru

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 k More

$160 USD in 4 days
(33 Reviews)
5.2
nizamfarhas

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 de More

$120 USD in 3 days
(19 Reviews)
5.4
sejaltanna

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 More

$200 USD in 7 days
(44 Reviews)
5.1
rnawaz

Hi there, I am php expert with lot of experience in csv data manipulation. I have recently done similar project. Please get in touch and I will deliver you a solution in a day or two. Best regards Rab

$140 USD in 7 days
(18 Reviews)
5.0
yash99nimavat

Hello, we are team of experienced and professional developers and designers. we believe in deliver best quality product to our clients. for more information visit our website [login to view URL]

$115 USD in 5 days
(16 Reviews)
4.6
vw8098368vw

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
(7 Reviews)
4.2
adibonchis99

Hello I hope you are doing well. I have many experiences in manipulating excel data. A few weeks before, I have completed the projects that parse the two xls files into array and compare them and display the result. I More

$40 USD in 1 day
(4 Reviews)
2.6