Discuss fixed width file import in the Microsoft Access Help forum on ASP Free. fixed width file import Microsoft Access forum discussing questions and answers for the Access database. MS Access is used to handle small to medium database needs.
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
fixed width file import
hi. i'm new here so... hallo to all URL
i've got a question concerning fixed width file import.
i've a three types of rows in a file. A - header row, C - data rows, and E - not used. my question is: how to update each C row with some data from A row during import? i'm attaching a source file
with one A record and two E records, and an example of required result table with the date taken from A record placed in each row of additional column. would be great if somebody can help me with vba code or any query solution.
Posts: 5,126
Time spent in forums: 4 Days 1 h 2 m 51 sec
Reputation Power: 12
The only way to you to do this is to open the text file using VBA and go line by line through your data and do what you want and then add it to you table.
ASP Free Forums Sponsor:
February 17th, 2004, 08:19 AM
fixed width file import
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
