Check before Importing txt file

  • Thread starter Thread starter Junior
  • Start date Start date
J

Junior

DB imports a txt file that is downloaded from a mainframe - all works well -
Unless the user FTPd the file in binary vs ascii
is there a way to check a file contents before actually importing it?
if not, is there a way to inspect a file after it is imported into access...
the program just hangs if the user forgets the download the data as ascii
txt.
Short of getting a new user, any suggestions on 'idiot proofing'
 
Junior said:
DB imports a txt file that is downloaded from a mainframe - all works
well - Unless the user FTPd the file in binary vs ascii
is there a way to check a file contents before actually importing it?
if not, is there a way to inspect a file after it is imported into
access... the program just hangs if the user forgets the download the
data as ascii txt.
Short of getting a new user, any suggestions on 'idiot proofing'
Click to expand...

You can certainly open the file directly for input, read a few bytes,
and see if they look okay. You'd use the VB Open, {Get, Input, or Line
Input), and Close statements for this.
 
Back
Top