Import Excel File into Database and import from another Excel File data to the related imported data.
Budget: €30 – €250 EUR
I have excel files with many data (over 130 columns). These excel files consists of soccer matches with results and their related numbers (Odds). All are seperated into countries. Otherwise all in one would be too big for excel.
The other excel file (80 columns) consists also of soccer matches with results BUT with Goal Timings which are missing in the file where all numbers (Odds) are.
So this means, when the columns of the file with numbers (Odds) is like this in excel:
Date, Country, League, Home Team, Away Team, Results, Odds
I need to put from the other file the columns of goal timings into the file with numbers (Odds) between the columns Results and Odds. It must be like this:
Date, Country, League, Home Team, Away Team, Results, GOAL TIMINGS, Odds
1. I need a database because all data are too huge for Excel.
2. The columns Goal Timings of the other file must be pasted EXACTLY to the related matches from the another file. I dont know if this work should be done before importing all in one into database or firstly import the other files into database and then pasting the Goal Timing to the related matches.
3. At the end when everything is finished, i have to do almost the same like in Excel in the database. Especially filtering all columns and refresh/reset. I need to work with it. Maybe a database with excel export function. Afew columns should be also with special colour but this i can show you later.
Please only serious offers and as soon as possible. For any questions feel free to contact me.
The other excel file (80 columns) consists also of soccer matches with results BUT with Goal Timings which are missing in the file where all numbers (Odds) are.
So this means, when the columns of the file with numbers (Odds) is like this in excel:
Date, Country, League, Home Team, Away Team, Results, Odds
I need to put from the other file the columns of goal timings into the file with numbers (Odds) between the columns Results and Odds. It must be like this:
Date, Country, League, Home Team, Away Team, Results, GOAL TIMINGS, Odds
1. I need a database because all data are too huge for Excel.
2. The columns Goal Timings of the other file must be pasted EXACTLY to the related matches from the another file. I dont know if this work should be done before importing all in one into database or firstly import the other files into database and then pasting the Goal Timing to the related matches.
3. At the end when everything is finished, i have to do almost the same like in Excel in the database. Especially filtering all columns and refresh/reset. I need to work with it. Maybe a database with excel export function. Afew columns should be also with special colour but this i can show you later.
Please only serious offers and as soon as possible. For any questions feel free to contact me.