Suoritettu

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

Taidot: PHP, MySQL, Excel, tietojärjestelmäarkkitehtuuri, SQL

Näytä lisää: 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

Tietoa työnantajasta:
( 11 arvostelua ) Dubai, United Arab Emirates

Projektin tunnus: #27463715

Myönnetty käyttäjälle:

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 Lisää

$140 USD 3 päivässä
(333 Arvostelua)
7.7

31 freelancers are bidding on average $165 for this job

(163 arvostelua)
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 7 päivässä
(538 arvostelua)
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 Lisää

$444 USD 7 päivässä
(55 arvostelua)
7.6
(553 arvostelua)
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 Lisää

$160 USD 7 päivässä
(251 arvostelua)
7.4
(103 arvostelua)
7.3
(177 arvostelua)
7.0
(51 arvostelua)
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 Lisää

$200 USD 7 päivässä
(55 arvostelua)
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 1 päivässä
(23 arvostelua)
5.8
webhipe

Hello How are you? i have read your details careufully. i have good experience with php projects. i am confident to finish your projects. i am familair with mysql. i also have good experienc with schedule script. so i Lisää

$140 USD 7 päivässä
(16 arvostelua)
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 Lisää

$140 USD 1 päivässä
(70 arvostelua)
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 2 päivässä
(28 arvostelua)
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 1 päivässä
(96 arvostelua)
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 Lisää

$160 USD 4 päivässä
(32 arvostelua)
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 Lisää

$120 USD 3 päivässä
(19 arvostelua)
5.4
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 7 päivässä
(16 arvostelua)
4.9
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 Lisää

$200 USD 7 päivässä
(44 arvostelua)
5.1
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 5 päivässä
(15 arvostelua)
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 10 päivässä
(7 arvostelua)
4.3