DoCmd.TransferText method is corrupting data.
Posted on 2003-02-25
I have an MS Access 97 database whose tables are being populated from Windows text files through a VB executable.
The VB executable, after opening the database, runs the following command using the MS Access DoCmd method:
oMS.Application.DoCmd.TransferText , , sTable, sLoadFile, True
The tables are populated as expected, but, accented letters (used in Spanish words for example) are replaced with other symbols (such as Greek characters).
If I "manually" import the same text files, Access correctly interprets the accented letters without a problem.
Are there any undocumented parameters for the Access DoCmd.TransferText method which will preserve the accented letters?
Only the 'automation' method appears to have the problem.