W
WorkSpace
my imported txt file looks like:
1 [junk record]
2 [junk record]
3 aaaaaaaaa
4 bbbbbbbb
5 ccccccccc
6 [junk record]
etc. etc.
In Access2000 I need to get recs 3,4,5 in the same record like:
[field1] [field2] [field3]
aaaaaaa bbbbbbbb cccccccc
If you can get me this far I know how to use InStr.
I hope this isn't brain surgery.
Thanks for your time.
..
1 [junk record]
2 [junk record]
3 aaaaaaaaa
4 bbbbbbbb
5 ccccccccc
6 [junk record]
etc. etc.
In Access2000 I need to get recs 3,4,5 in the same record like:
[field1] [field2] [field3]
aaaaaaa bbbbbbbb cccccccc
If you can get me this far I know how to use InStr.
I hope this isn't brain surgery.
Thanks for your time.
..