Find Jobs
Hire Freelancers

update an Excel spreadsheet with an sql query of a database

$10-30 USD

Selesai
Dibuat hampir 9 tahun yang lalu

$10-30 USD

Dibayar ketika dikirim
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.
ID Proyek: 7737806

Tentang proyek

5 proposal
Proyek remot
Aktif 9 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
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 dalam 1 hari
5,0 (3 ulasan)
5,2
5,2
5 freelancer menawar dengan rata-rata $31 USD untuk pekerjaan ini
Avatar Pengguna
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 dalam 1 hari
5,0 (60 ulasan)
5,6
5,6
Avatar Pengguna
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 dalam 1 hari
5,0 (24 ulasan)
4,6
4,6
Avatar Pengguna
La propuesta todavía no ha sido proveída
$25 USD dalam 3 hari
5,0 (1 ulasan)
3,3
3,3
Avatar Pengguna
A proposal has not yet been provided
$25 USD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera UNITED STATES
United States
5,0
1
Memverifikasi Metode pembayaran
Anggota sejak Mei 25, 2015

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.