VBAinspire
Programmer
In Microsoft Access 2000, I am importing text files from multiple users and then programmatically reading the text files to determine what data the files contain. My problem is that some of the files are created in UNIX and some are created in Windows. Access sometimes has problems finding the end of the first line.
I am using the following method:
object.OpenTextFile(filename[, iomode[, create[, format]]])
In VB it is possible to set the format to "TristateMixed" which opens either Unicode or ASCII formatted files.
In VBA there was no "TristateMixed" option, just a choice between Unicode and ASCII.
Any suggestions?
Thank you!!!
I am using the following method:
object.OpenTextFile(filename[, iomode[, create[, format]]])
In VB it is possible to set the format to "TristateMixed" which opens either Unicode or ASCII formatted files.
In VBA there was no "TristateMixed" option, just a choice between Unicode and ASCII.
Any suggestions?
Thank you!!!
