Textfiles (txt,csv) are not opened correctly .
The SolutionYou will have to create a schema.ini which describes the textfile. Place it in the same directory as the textfile. The schema.ini must contain the filename of the textdatabase and the separator.
For example:
[MyTextfile.txt]
ColNameHeader=True
Format=Delimited(;)
MaxScanRows=0
CharacterSet=ANSI
For more info go to:
http://support.microsoft.com/kb/210073