PLEASE HELP: detect charset of a dbf file.

Hi!

I have a programs that import and export database entry in visual basic. The problem is that I have a lot of database tables in dbf files. (each dbf file is a table)

When I open tables with a recordset, some of them are open in oem character set and others are open in ANSI character sets.

I need to be able to detect if a dbf database table file will open in oem or ansi character set OR I if possible, open any table in the specified character set.

P.s.: I also use a data object to connect to my dbf database.