W
WembleyBear
Hi
I need to import data from our Nominal Ledger into a simple database table.
The file from the NL is a csv and contains only 4 fields: Cost Centre,
Expense Code, Current & YTD.
In my database, I need to append the records to a table called Nominal which
has the following fields:
Nmonth
Nyear
Cost Centre
Expense Code
Current
YTD
My questions are:
1. I want the user to be able to select the Year and the Month for the file
they are going to import from drop-down boxes on a simple form and click a
button to import. The records in the csv file should then be imported to the
Nominal table, along with the year and month on each record as selected by
the user. What is the best way to accomplish this (taking into account part 2
of my question below)?
2. Due to accounting journals, the same import may need to be performed
several times. When a year and month is selected that already has records,
these should be removed before the new data is imported.
Step by step please as not very experienced with Access! Many thanks for
your help
Martyn
I need to import data from our Nominal Ledger into a simple database table.
The file from the NL is a csv and contains only 4 fields: Cost Centre,
Expense Code, Current & YTD.
In my database, I need to append the records to a table called Nominal which
has the following fields:
Nmonth
Nyear
Cost Centre
Expense Code
Current
YTD
My questions are:
1. I want the user to be able to select the Year and the Month for the file
they are going to import from drop-down boxes on a simple form and click a
button to import. The records in the csv file should then be imported to the
Nominal table, along with the year and month on each record as selected by
the user. What is the best way to accomplish this (taking into account part 2
of my question below)?
2. Due to accounting journals, the same import may need to be performed
several times. When a year and month is selected that already has records,
these should be removed before the new data is imported.
Step by step please as not very experienced with Access! Many thanks for
your help
Martyn