I have one flatfile that has 48 data columns(24 for units and 24 for values) that i need to convert automatically to access. As a parameter i need that the aplication to ask which is the first month to upload, than the aplication needs to convert the first unit column to the first month, the first value column to the first month, the second unit column to the next month, ...
The target acces must have the main flat file columns(FCC, Brick, ) and a new column for month(aaaamm), a column for unit and a column for value.
Attached a xml with the flatfile structure, a small example of the flatfile and the target access.
Thanks a lot, Roberto