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.
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.