Find Jobs
Hire Freelancers

update an Excel spreadsheet with an sql query of a database

$10-30 USD

Fullført
Lagt ut nesten 9 år siden

$10-30 USD

Betalt ved levering
I am trying to compare two sets of data and update one from the other. My main database has approx 10000 items and their prices change constantly. It is an sql database. My website has about 500 products and I want to update those prices once a week using the prices contained in our master database. Ideally: I would export a list of the products on the website to a .csv file and import into Excel, with only the following fields: SKU, price and quantity. Then I'd have Excel query the SQL database for matches on each of those SKU's, with a return of price and quantity. I would then upload the updated list back to the website. What I need done is to have someone write the query that would check each record in my list of web products against my main database and update the price and quantity fields for each SKU that had a change. And secondarily, to then flag each changed record so we could then upload only those that were changed back to our website. We would then need instructions on how to set it up at our end and what commands our staff would need to execute to run this process each week.
Prosjekt-ID: 7737806

Om prosjektet

5 forslag
Eksternt prosjekt
Aktiv 9 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
Tildelt til:
Brukeravatar
There has GOT to be a better way. Why are you using 2 databases? That (from what i understand ) is the issue. In your scenario below it is unclear what each database is? Do you know you can access the SQL database on the web with Excel? Make your changes and be done with it . Or have a little app that connects to the web database and use it to make the changes. Anytime you have data in more than one place it is a sign of a design issue.
$25 USD om 1 dag
5,0 (3 omtaler)
5,2
5,2
5 frilansere byr i gjennomsnitt $31 USD for denne jobben
Brukeravatar
Hello, I am very much interested to do this work by .Net as i have similar experience by it. It will have a simple form where you will browse your data file and it will do the required task and export the required data. I think i can do this work efficiently and quickly. Looking forward to have a positive response from you. Thanks
$24 USD om 1 dag
5,0 (60 omtaler)
5,6
5,6
Brukeravatar
Hello there. Let me ask you something: 1) are both database SQL server? (your local and your web databases? If so, you can avoid Excel 2) will be the SKUs in your local database updated entirely with their related SKUs on the web?. If so, You only need a "Query" in Sql Server Managment to update the web table according with the info in the local table. (both databases will be visible in your Sql Server management) let me know... I use TeamViewer to connect myself into your network.
$55 USD om 1 dag
5,0 (24 omtaler)
4,6
4,6
Brukeravatar
La propuesta todavía no ha sido proveída
$25 USD om 3 dager
5,0 (1 omtale)
3,3
3,3
Brukeravatar
A proposal has not yet been provided
$25 USD om 1 dag
0,0 (0 omtaler)
0,0
0,0

Om klienten

UNITED STATESs flagg
United States
5,0
1
Betalingsmetode bekreftet
Medlem siden mai 25, 2015

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.