DBCS and MS Access

[J]

I am importing an excel spreadsheet with japanese characters into a
table in MS Access. I open the table after the import, I can see the
characters fine. If I export the data back to an excel, it is fine too.

I am creating a text file with this data. I export this to a text file
using DAO recordset, it appears as "???????" in the text file.
Any idea.

[MGFoster]

J wrote:

I am importing an excel spreadsheet with japanese characters into a
table in MS Access. I open the table after the import, I can see the
characters fine. If I export the data back to an excel, it is fine too.

I am creating a text file with this data. I export this to a text file
using DAO recordset, it appears as "???????" in the text file.
Any idea.

Are you directly exporting the table? Perhaps if you used a query to
export the data it will be translated from DBCS to 1-byte char set.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

[J]

I am using
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8,
strCntryTab, strFile, Yes
to export the excel data into MS Access table. The data looks fine in
the table after importing. After that I have a routine which creates a
recordset and points to this table. This is where it reads ??????. I am
reading one record at a time to send it to a text file.