trouble with data in text file

[asramala]

Hi-

I have a text file with data in fixed width format. I'm trying to get the data into a format that I can use to link the data to some other tables (.dbf, or in Access or Excel). The problem is that there are carriage returns within the records, so one record takes up more than one line. I can't seem to do the formatting when I import the data using the wizards in Excel or Access. I do not have much experience with fixed width text files, so I would greatly appreciate any advice. I am willing to write VB code, if there is no easy alternative. Thanks!

 

[repete]

I realize there has been some time that has passed since you posted your question, but if you have an example of your file that you can send me, I will look at the conversion for you.

pete.bloomfield@calendarclub.com.au



Pete Bloomfield
Down Under