A
Adrian
I am importing an excel spreadsheet that I need to normalize so it can fit
into my database. Since I will get a new spreadsheet every month I will need
to repeat the process. I figured it would be easier to write a query or
series of queries in Access to convert the spreadsheet rather than fixing it
in excel everytime.
My source spreadsheet has one record per person with a pay from date and a
pay thru date. The problem it also has several different columns for
payment/deduction types.
this is the table as is
ID Name Pmt1 Pmt2 Pmt 3 Ded1 Ded2 Ded3 Ded4 PayFrm PayThru
I would like to convert the payment and deduction columns into two fields,
one for type and one form amount so that I can append the data to the
following table.
ID Name PayType Amt PayFrom PayThru
I have seen a couple of answers that suggest a union query but I am a little
unclear on the syntax and I want to confirm that if I do this on monthly
basis that I add the new data to the table and not overwrite last month's
info.
into my database. Since I will get a new spreadsheet every month I will need
to repeat the process. I figured it would be easier to write a query or
series of queries in Access to convert the spreadsheet rather than fixing it
in excel everytime.
My source spreadsheet has one record per person with a pay from date and a
pay thru date. The problem it also has several different columns for
payment/deduction types.
this is the table as is
ID Name Pmt1 Pmt2 Pmt 3 Ded1 Ded2 Ded3 Ded4 PayFrm PayThru
I would like to convert the payment and deduction columns into two fields,
one for type and one form amount so that I can append the data to the
following table.
ID Name PayType Amt PayFrom PayThru
I have seen a couple of answers that suggest a union query but I am a little
unclear on the syntax and I want to confirm that if I do this on monthly
basis that I add the new data to the table and not overwrite last month's
info.