I need some VBA code to regularly update a table in an MS Access DB from a text file. A sample of the file is located here [login to view URL] - I only want the body of the text file not the headers - Once imported I need to sort by date. - In the text file there are there are 2 lines per transaction. I need to get these on to one line in the DB. - In the DB I need the following fields. Date, Debit Amount, Credit Amount, Balance and Description. - Each time I dump the text file it will likely contain data that has already been imported. I only need to append new data to the table.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
MS Access 2000