I have checked the archives ("read text file" = 291 hits) but nothing helped :-( I'll save a long story ... the following is what I have to work with and I need to read it into access :-) or excel :-( . The file is formatted as follows:
Mrs Whoever Last Active Date: 23/12/1997 12:07:05 Overdue Fines: $3.30 Total Bills: $0.00 Total Misc.: $0.00 Total Owed: $3.30 Items Overdue: 0 Total claims returned: 0 Active claims returned: 0 Tracey-Anne Whoever Last Active Date: 16/06/1997 17:15:55 Overdue Fines: $36.00 Total Bills: $0.00 Total Misc.: $0.00> Total Owed: $36.00 Items Overdue: 0 Total claims returned: 0 Active claims returned: 0
Just typed a template code which can be used to approach your task solution assuming that your file has the fixed structure you described. Just run it supplying your file path to see how it works. Can be used from both MS Access 97 and MS Excel 97(after correction of header lines - options database etc.).
P.S. It should be easy to extend this code to convert and store attributes(fields) into the target table
Copyright © 1999-2008 by Shamil Salakhetdinov. All rights reserved.