Recent content by phient

I'm using the Get External data in Access which pulls the text file and splits the field headers into field 1 and the associated header's data into field 2. I'm trying to grab each data group and append to an appropriate table that has the headers already as field names: [Group 1] Header 1...

Hi, I'm new to VBA in Access and need help/suggestions on how to do the following: I have a large text file that I'm importing into Access that has 5 groups of data in 2 fields (Header and Data) without a primary key or any way to associate the following data to the group/report header...