Exporting Data in Other File Formats

In addition to text and Web-based formats, you can export data to any other file format that Access can import. Access supports exports to the following file formats:

• Excel .xls files (versions 3.0 through 11).

• Lotus 1-2-3 .wk? files.

• Paradox 3.x, 4.x, 5.0, 7.x, and 8.x; versions 7.x and 8.x require the BDE.

• dBASE III/III+, IV, 5.0, and 7.0; version 7.0 requires the BDE.

• Any format supported by an installed ODBC driver, including client/server databases. Exporting Visual FoxPro files is subject to the limitations described earlier in the chapter.