Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

DoCmd.TransferText method is corrupting data.

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.

0
colin4
Asked:
colin4
1 Solution
 
nexusnationCommented:
sorry, but there is no parameter. however, you can run update queries to find each symbol and replace with it's corresponding letter (as different non-recongized letters should have their own corresponding symbol).

getting the idea?

Andrew
0
 
1WilliamCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept question, points to nexusnation
Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
1William
EE Cleanup Volunteer
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now