Import Issue 1

[ep1]

I have a text file that has 30K rows of data. I did search the site and I was unable to see that this issue has been discussed previously. The rows have data up to 700 bytes. When I import the file as a single memo field that has a width from 1 to 700 the beginning and end are exactly in order as in the text file however the middle is out of order. The rows are all alpha numeric but they do all start with numbers between 0 & 6. The middle jumble has subsections that appear to be in order as a subsection but not in order as they should be in relation to the whole file. Can someone please tell me what happened and if I can mitigate this?



Thank you kindly for your help,

Ep

 

[genomon]

Why are you importing the file as a single memo field?

Cogito eggo sum – I think, therefore I am a waffle.

 

[ep1]

Genomon,

I use memo because text errors out saying missing search key. I wanted Access to read it in the same order as the Text I then grab a flag(Y/N) in position 674 and return back to text form (again hopefully in the same order) with only the Y flag records which happens to be the vast majority of records. From a high level I remove some record lines which are intermingled in the file.

Any help would be appreciated.

Thank you kindly for your time,

Ep

 

[genomon]

I would use the File Scripting Object in VBA and bring the file in as either a TextStream or flat file, then manipulate it (parse it).

Cogito eggo sum – I think, therefore I am a waffle.

 

[boblarson]

I use memo because text errors out saying missing search key."

That, is an indication of corruption in the database, by the way.

You might need this

http://allenbrowne.com/ser-47.html

Bob Larson
Free Access Tutorials and Samples:

http://www.btabdevelopment.com

 

[ep1]

Thank you both Bob & Genomon,

I went with a scripting function that used TextStream to solve my issue. I was unable to find anything on Allen Browne to fix any corruption and now I will go forward from here.

Thank you again,

Ep