I have a text file that is downloaded in a format unusuable without doing column mainpulation in excel with various formulas. For Example I use IF(B:2)="",(B:1),(C:2) to have a field name populated into empty cells. I would like some VBCode that can allow the Database to run through and populate the fields with the previous record's data if the same field is Null in the Current Record using a primary number ID or some other method that will work on a monthly basis with the same file. Can send Sample Spreadsheets showing current methods.
1) Complete and fully-functional working Access 2000 database using the provided text file reworked in necessary format as well as complete source code of all work done.
MS Access 2000