In Progress

Simple database query

This is an easy database project. We have 3 x Excel files that contain emails.

Spreadsheet 1 – this is the main email table that we want to maintain

Spreadsheet 2 and Spreadsheet 3 – the contain emails that may also be in table 1

Create a Database structure in Open Office. The database structure will contain 3 tables. Each table will be fed by an individual Excel spreadsheet. Automatically import the data from the excel spreadsheet into the table.

Spreadsheet 1 = import into Table 1

Spreadsheet 2 = import into Table 2

Spreadsheet 3 = import into Table 3

Then run a query that will:

• Check emails that are in the main Table 1 and to see if they feature in Table 2. If there are matches then remove them from Table 2 only.

• Check emails that are in the main Table 1 and to see if they feature in Table 3. If there are matches then remove them from Table 3 only.

After running this query, Table 1 will contain unique emails. There will be no email in Table 1 that is in either Table 2 or in Table 3.

Easy.

I need the completed database structure and an easy way to run this query again and again.

Please respond with evidence of your capabilities. Once I select a coder, I will send you the spreadsheet files.

Skills: Excel, MySQL

See more: excel database query, simple data structure, n query, open office project, simple query, send query, query table, import database, data query, easy database project, excel spreadsheet feature, check data excel files, mysql excel query, import database excel mysql, excel query mysql, mysql spreadsheet, query spreadsheet, mysql import excel table, query email, mysql excel import data, mysql import select database, import data mysql excel, check excel files, mysql remove table, excel spreadsheet structure

About the Employer:
( 18 reviews ) gateshead, United Kingdom

Project ID: #1149212

Awarded to:

steve1112

Kindly check PMb! ;)

$50 USD in 1 day
(3 Reviews)
2.0

7 freelancers are bidding on average $49 for this job

webphp

hello, lets start.

$40 USD in 0 days
(47 Reviews)
5.4
zaidkhankarachi

I have done it before......contact at PMB thanks

$45 USD in 2 days
(1 Review)
2.5
rbsaud

please check pm.

$100 USD in 1 day
(2 Reviews)
2.0
divinedts

Hi please read pm.

$30 USD in 1 day
(2 Reviews)
1.6
anuragmeet2day

Hello Please check pm for demo

$50 USD in 2 days
(0 Reviews)
0.0
shrutivaidya16

Yes, I can do your project. I will complete it in a stipulated time period.

$50 USD in 2 days
(0 Reviews)
0.0
Megha000824

Dear Sir, Pls. send me the EXCEL file. Thks/Rgds Saliya

$30 USD in 1 day
(0 Reviews)
0.0