Find Jobs
Hire Freelancers

update an Excel spreadsheet with an sql query of a database

$10-30 USD

Completato
Pubblicato quasi 9 anni fa

$10-30 USD

Pagato al completamento
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.
Rif. progetto: 7737806

Info sul progetto

5 proposte
Progetto a distanza
Attivo 9 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
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 in 1 giorno
5,0 (3 valutazioni)
5,2
5,2
5 freelance hanno fatto un'offerta media di $31 USD
Avatar dell'utente
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 in 1 giorno
5,0 (60 valutazioni)
5,6
5,6
Avatar dell'utente
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 in 1 giorno
5,0 (24 valutazioni)
4,6
4,6
Avatar dell'utente
La propuesta todavía no ha sido proveída
$25 USD in 3 giorni
5,0 (1 valutazione)
3,3
3,3
Avatar dell'utente
A proposal has not yet been provided
$25 USD in 1 giorno
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: UNITED STATES
United States
5,0
1
Metodo di pagamento verificato
Membro dal mag 25, 2015

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.