About importing, exporting, and linking right-to-left tables in text formats

Microsoft Office Access 2003

Show All Show All

About importing, exporting, and linking right-to-left tables in text formats

The feature described in this Help topic is only available if support for right-to-left languages is enabled through Microsoft Office Language Settings.

In addition, to enable the right-to-left features in Microsoft Access, you must be running a 32-bit Microsoft Windows operating system that has right-to-left support— for example, the Arabic version of Microsoft Windows 2000.

Access provides code page conversion of tables and worksheets with right-to-left characteristics for text files stored in logical text layout, with one of the following right-to-left code pages:

Language Code page
Arabic UTF-8 (default)
ISO 8859-6
DOS-720
ASMO-708
Hebrew UTF-8 (default)
ISO 8859-8
DOS-862

To import, export, or link text files that are not recognized by Access, use ConvText.exe, a stand-alone text-file conversion utility that provides both logical and visual text layout options and an expanded list of supported bidirectional code pages. ConvText.exe is available on the Microsoft Office Web site and on the installation CDs for Microsoft Office language versions that offer right-to-left support.

Note  A table or worksheet in Lotus, dBASE, Microsoft FoxPro, Paradox, or ODBC database format that requires code page or text layout conversion can still be imported into Access by saving the table or worksheet in text file format prior to importing it. The ability to save a table or worksheet in text file format is a standard feature of most database or spreadsheet products. When Access imports the text file, all field names and records from the original table or worksheet will be fully recreated in a new Access table.