Hi all, I have an issue that I'm stuck on:
I have a .txt file approx. 675,000 but only about 9,000 unique records. I want to get a table of unique records. There are actually no duplicate records in the file, it's just the format of the data. For example, it comes like this:
ID: 1
Name: Mr. Smith
Age: 50
Email: email address
Join Date: 1/1/11
And so on for 75 fields per record (thus the 675k or so total rows in the .txt file) I'd like to convert it to the standard access table format so i can email everyone in the database.
Anyone have any thoughts on extracting this data? I've managed to extract the data portion of the row using instr, and I was just going to append all the data together, but it needs a common field to link on.
Any help is appreciated!