I'm trying to help my wife create a real estate database which will populated with values imported from non-fixed width, non-comma delimited text files. An example copy of the text file is attached.
The relevant field names and corresponding information are contained in the text file.
Some of the fields are contained in a single line (example below)
Price Per Sqft: $394.80
However, other lines contain multiple fields (example below)
AC: Y Pool: N
I've captured 3 or 4 files and it appears that data for each field appears in the same position on each line uniformly from file to file.
20 years ago, back in the old dBase days, I had a program that would read and convert a text file like this. You could bring the file into its template builder to visually map the field identifiers and the number of characters containing the field data. Once the template was built, it was a simple matter to batch convert text files into .dbf files.
Damn, it's bothering me that I can't remember the name of the program.
Is there something out there in today's world that does the same thing? I simply need to get the data into a format readable by MS Access 2003. Any freeware? If nothing out there exists, is there a simple solution in Access?
Any responses would be greatly appreciated. Thank you!