Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OpenTextFile Method - mixed tristate format???

Status
Not open for further replies.
VBAinspire

VBAinspire

Programmer
Aug 8, 2001
10
0
0
US
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!!!
 
Status
Not open for further replies.

Similar threads

wmbb
  • Locked
  • Question
How can I format values to always display as E-10
Replies
5
Views
70
strongm
strongm
kskinne
  • Locked
  • Question
VBA to conditionally delete rows - need faster method
Replies
5
Views
49
SkipVought
S
Mehrez Kanzari
  • Locked
  • Question
How to fix a messed Excel sheet and make a proper format?
Replies
4
Views
62
Andrzejek
Andrzejek
JasonEnsor
  • Locked
  • Question
Excel vba xlsm to xlsx format 51, not removing macros
Replies
3
Views
94
JasonEnsor
JasonEnsor
renigar
  • Locked
  • Question
VBA, export public calendar data from outlook 2010 in format usable by excel
Replies
2
Views
41
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top