I need to know how, if possible, I can import data into an access table from a text file that is in the form of data records instead of in a column format. Here’s an example of 1 record:
event-type , alarm
application-type-id , 15
application-name , AMF
application-version , 1.0.0
name , AMF
number , 1300
description , Service group redundancy.
suppression , allowed
So far I’ve created a table in Access with the column headings (event-type, application-type-id, etc). However, since the field names are not in columns in the text document, but are the first field of each line, then I can’t seem to figure out how to get Access to import just the 2nd field entries under the corresponding columns in the table I’ve created.
Is what I’m trying to do possible in Access? There are about 100 records in the text file so it’s a bit too much to go through and manually reformat everything into columns. Any help would be appreciated.
I forgot to mention that I tried importing into Excel too, but ran into similar issues.