I would like to down load different CVS files from different financial institutions
Some CVS files have headers some don't
I would like to import and append them into one table called transactions
It would be nice to press an import and select a pre defined mapping for the different files
Also I wish to identify the source of this file so each transaction would say the source let's say from Chase and another from Wells Fargo
Any suggestions?
I'm assuming a custom button to a form to do the mapping and name and save this mapping
Then another button to import and append to select the pre defined mapping.