Est. Budget: $15.00
We have a tiny database (3 tables) with few records. Table C is linked to table A,B.
We want to compare the entries from table C with 2 excel files (Raw extract) :
- Create a linked table with the 2 excel files. (OK)
- Create a query which compares Table C with File A and retrieve informations.
- Create a query which compares Table C with File B.
- The excel files has some flaws (such as special characters, space, date format ...