I need an Access DB created that will import 2 different text files (ideally from html containing an html table, but can also be manually converted to csv beforehand - I would prefer html) into 2 Access tables (approx 7 columns each - spec available).
This import utility will be manually done by a user each day for a different daily set of daily data. When the data is inserted into the table, it must have a column identifying the date on which it was imported (this value will be entered by a user). The whole thing will be controlled by a form or macro.
There will be some cleanup of the data required on import (trim text of excess spaces).
There will be further stages of this project, but for now, this is the basis.
I attach a spreadsheet showing the data from each day (as manually copied from HTML to Excel)
I will be available to answer detailed questions to developer.