P PGMR_1998 New member Local time Today, 21:11 Joined May 21, 2003 Messages 9 May 21, 2003 #1 anyone no how i can import a text file that has 3 lines of data for each record. my problem is that access makes each row into a record. but i want each set of 3 rows to be a record. please help!!!
anyone no how i can import a text file that has 3 lines of data for each record. my problem is that access makes each row into a record. but i want each set of 3 rows to be a record. please help!!!
W WayneRyan AWF VIP Local time Today, 21:11 Joined Nov 19, 2002 Messages 7,122 May 21, 2003 #2 PGMR_1998, Hey, we just did something like this yesterday. If you can post a small sample of the file and the structure of the table you want the data put into we can go from there. Wayne
PGMR_1998, Hey, we just did something like this yesterday. If you can post a small sample of the file and the structure of the table you want the data put into we can go from there. Wayne
P PGMR_1998 New member Local time Today, 21:11 Joined May 21, 2003 Messages 9 May 21, 2003 #3 the file structure for the mdb should be exactly as the input test file. attached is a sample of the input text table. Attachments a00table.txt a00table.txt 11.4 KB · Views: 187
the file structure for the mdb should be exactly as the input test file. attached is a sample of the input text table.
W WayneRyan AWF VIP Local time Today, 21:11 Joined Nov 19, 2002 Messages 7,122 May 21, 2003 #4 PGMR_1998, I have a db that correctly reads in your data, BUT it does not know how to handle the Amendments and Supplements. They greatly complicate matters. Will continue later, have to work. Wayne
PGMR_1998, I have a db that correctly reads in your data, BUT it does not know how to handle the Amendments and Supplements. They greatly complicate matters. Will continue later, have to work. Wayne
W WayneRyan AWF VIP Local time Today, 21:11 Joined Nov 19, 2002 Messages 7,122 May 21, 2003 #5 PGMR_1998, One last thought for a while. This data is really a report produced by something. What produced it? It might be easier for you to extract the data from that source. Let me know. Wayne
PGMR_1998, One last thought for a while. This data is really a report produced by something. What produced it? It might be easier for you to extract the data from that source. Let me know. Wayne
P PGMR_1998 New member Local time Today, 21:11 Joined May 21, 2003 Messages 9 May 21, 2003 #6 Wayne, u are right. I will try that approach. Thanks for your thoughts...
