Is It Possible To Import A Portion of a Text File?

[lrdave36]

Hi guys,


I have a text file that has the data broken up into 3 different sections. It is fixed width. I need each section to be placed in a seperate table.

Is there any way to do this in the import wizard? I could specify a line number as the cut off point.

 

[vbajock]

I know of no way to do it with the wizard, you'd have to code it.

 

[jeffmorl]

have you tried converting the data into a delimited excel file and then importing it through the wizard?

 

[alvechurchdata]

I'd suggest that you import the entire text file and then use queries to break it up. It's much easier to manipulate data once it's inside Access.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[lameid]

If each record type has the same number of fields, definitely import first and then normalize.

If not, you can go two routes....

Import each row into one column and code the break out into fields and load the tables seperately.

Alternately, you can open the text file via VBA, read the file line by line, figure out the destination filetype and write conditionally to three seperate files and then import each of those.