Database file formats

Vertex42 The Excel Nexus

Professional Excel Templates

Get Instant Access

Table 4-4 lists the database file types supported by Excel 2007. All database file formats are limited to a single worksheet.

Table 4-4: DATABASE FILE TYPES

^ Open table as spreadsheet

Table 4-4: DATABASE FILE TYPES

^ Open table as spreadsheet

File Type

Extension

Read/Write

Notes

Access

mdb, mde, accdb, accde

Yes/No

You can open one table from the database.

File Type

Extension

Read/Write

Notes

dBASE

dbf

Yes/No

The file format originally created by Ashton-Tate

Others

Various

Yes/No

By using the commands in the Data 1 ■ Get External Data group, you can import data from various data sources that have connections or queries defined on your system.

Was this article helpful?

0 0

Post a comment