I'm trying to make this process for an end-user as smooth as possible. I need to be able to skip the wrong EOF.
1. The user exports 30 e-mails received daily from a MainFrame Computer in Lotus Notes to a .txt file.
(some of the e-mails contain hidden attachments that cannot not be removed and are translated by notepad into a
bunch of characters.)
2. Once the data is in the text file ( approx 6000 lines ), the text file is linked to Access.
Here comes the problem:
Access only displays 89 rows, since it finds characters like "€è²3þÿÝÝúÿÝÝúÿÝÝ€4þÿÿÿUS" and assumes that EOF
has been reached.
I don't want the user to go to the text file and delete all lines where characters like those above are present, I want to be
able to skip them all and see the 6000 rows in an Access linked table, so I can proceed with step 3.
3. A Pass-Through query will insert all rows into ORACLE for further manipulation.
Thanks a lot!