Closed

Create grocery database using excel or SQL

1. We have two excel files, Ex: File 1 and File 2.

2. File 1 contain barcode, price, images and other information. File 2 contain barcode and price columns.

3. Using File 2 we wanted to identify the barcodes that match with barcode in File 1. For matching barcodes, update the price details from file 2 into File 1.

4. The final output file should contain all the columns in File 1 with updated price details from file 2.

5. Unmatched barcodes products can be ignored/filtered out from the output file

Skills: Excel, SQL, Microsoft Access, MySQL, Database Programming

See more: create client database using excel, create client database ms excel, create oracle database tables using sql, create oracle database tables using sql ddl, create access database tracking excel file, create access database multiple excel files, create access database multiple excel, create access database from excel, express the fractions 3/4 7/16 and 5/8 with the lcd brainly, how to create a database in excel, how to create a database in excel 2016, how to create a database in excel 2013, how to create a database in excel 2010, how to create a database in excel 2007, how to create employee database in excel, create a database named 'phpmyadmin' and setup the phpmyadmin configuration storage there., how to create local database in oracle sql developer, how to create a database in excel 2010 pdf, how to create a database in excel 2016 pdf, which of the following is reported for interim financial reports using the discrete approach?

About the Employer:
( 2 reviews ) ARLESEY, United Kingdom

Project ID: #22240494

80 freelancers are bidding on average $22 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g More

$50 USD in 1 day
(733 Reviews)
8.5
schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha More

$50 USD in 1 day
(330 Reviews)
8.0
truongnguyen86

Hello there, i'm expert on data processing. This can be done either Excel(VLOOKUP function or VBA code) or SQL(Select join exist) to find the matching. Pls share me 2 files. Waiting for your response if interested. Tha More

$50 USD in 1 day
(176 Reviews)
6.9
MimiFL

Hi, this is something that can be done quickly, probably under 30 minutes in excel. If you are interested in working with me, please message me with sample files and i will try to help immediately. Thanks, Milan

$15 USD in 1 day
(507 Reviews)
7.0
ksriniravi

Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. Please share the file - I would write a small macro to produce output as required More

$20 USD in 1 day
(187 Reviews)
6.8
workerbee1974

Good day, My name is Donna. I have read your project description and I feel I am an ideal candidate.   I am a expert Microsoft  access database developer, I am also an expert in Microsoft Excel. I have completed all cl More

$35 USD in 1 day
(44 Reviews)
6.6
SergioAlfaroV

Hello! I am a SQL expert, MCSA SQL Server 2014 certified, with 14 years of experience in data analysis and SQL development. I can import your excel files into SQL Server Express, create a query to do the needed calcul More

$30 USD in 1 day
(22 Reviews)
5.7
attiqfreelancer

HOW MANY TOTAL PRODUCTS ARE THERE CAN YOU TELL ME THAT? I UNDERSTOOD WHAT YOU WANT I WILL DELIVER YOU FILE 1 ACCORDING TO YOUR DESIRES ASAP

$30 USD in 1 day
(32 Reviews)
5.3
sajidkhan45

Hi, I am an excel VBA expert and can complete this job by creating a code in VBA. It will automatic compare and make the required changes. Ill give you the final data as deliverable. Hope to chat with you soon mate! More

$30 USD in 1 day
(58 Reviews)
5.6
etuannv

Hi there, I am interested in your project. I would approach your project by making a program to merge the 2 files. I have 10+ years’ experience at programming. If you'd like to view my previous work, take a look at my More

$20 USD in 7 days
(11 Reviews)
5.1
serdaryalcin

Hi, Please send the Excel files, I can send you back the files tomorrow. If it is an homework, I am not doing it. Regards,

$30 USD in 2 days
(21 Reviews)
4.4
abhisa21

Hi Kindly share the files. It can be done using vlookup and I am readily available for the task. Look forward to hearing from you. Thanks Maria Isabel

$25 USD in 2 days
(11 Reviews)
4.3
mjanchi

Hello there. Please share this files with me I can make this easy. Thanks.........................................................................................

$30 USD in 1 day
(12 Reviews)
4.1
Aragornsan

Hi there, I can assist with this now if you want. I am an accountant from South Africa and I have extensive Excel and MSOffice experience. I specialise in excel report design, but can do most tasks needed in excel. I h More

$30 USD in 1 day
(7 Reviews)
3.9
AymunSaif

HI we are experienced in Excel Report Project, we are brilliant. We can start right now but we have few doubts and questions let’s have a quick chat and get it started waiting for your reply.

$20 USD in 7 days
(14 Reviews)
3.7
MohabSystems

Hi, I can help you with your task. I’m an experienced data scientist having more than 16 years of professional experience. I can help you with your data management need Following sections explains my skills and t More

$30 USD in 1 day
(10 Reviews)
3.3
sqlnr

Is this a once off or something you want to repeat? My preference would be to import the data into a database, create a table of the required output then export it. This gives a record of what has happened and gives a More

$20 USD in 2 days
(5 Reviews)
3.7
adricabrelles

Hi I am a Senior DBA with more than 15 years experience in sql. I cann help you. Regards.

$20 USD in 1 day
(8 Reviews)
3.0
DominikKrivarics

Hi, I can help you with this, it's up to you to decide if we solve it only with formulas or with a macro in excel. Please send me those 2 files so I can check and send back a sample solution. Thanks, Dom

$30 USD in 3 days
(5 Reviews)
2.6
NoSonforhim

I have 20 years in Database Developing, administration, Programming, System Analysis, Data Analysis using Ms. Access, Ms. Excel, VBA, VB6, Vb.net, C#, SQL, SQL/PL SQL, and MS SQL Server

$12 USD in 1 day
(5 Reviews)
2.5