import text file

[PGMR_1998]

how do i import a text file that has 3 lines of data for each record? when i import the file, access thinks each line is a new record, so i get 3 records for each true record.

 

[jfgambit]

Does each line have a unique identifier associated with it?

Example

123, Jim, Smith
123, Washington
123, Programmer
234, Mike, Jones
234, Delaware
234, President

 

[PGMR_1998]

no, each line does not have a unique id. but the first line of each record does. recall that each record consist of 3 lines.

 

[Pat Hartman]

Please don't post the same question in multiple forums. It wastes the time of the very people who are trying to help you. WayneRyan practically offered to write the code for you. I'd stick with him.

 

[PGMR_1998]

you are correct, and i offer my apologies. i thought that maybe i had posted on the wrong board. thanks...