Microsoft Office Tutorials and References
In Depth Information
File Types
Table 4-4: Database File Types
File Type
Extension
Read/Write
Notes
Access
mdb, mde, accdb,
accde
Yes/No
You can open one table from the database.
dBASE
dbf
Yes/No
The file format originally created by
Ashton-Tate.
Others
Various
Yes/No
By using the commands in the Data Get
External Data group, you can import data
from various data sources that have
connections or queries defined on your system.
Other file formats
Table 4-5 lists the other file types supported by Excel 2010.
Table 4-5: Other File Types
File Type
Extension
Read/Write
Notes
Hypertext Markup
Language (HTML)
htm, html
Yes/Yes
Beginning with Excel 2007, this file format
no longer supports “round-tripping.” If you
save a file and then re-open it, you may
lose information.
Single File Web Page
mht, mhtml
Yes/Yes
Also known as Archived Web Page. The
only browsers that can display these files
are Microsoft Internet Explorer and Opera.
OpenDocument
Spreadsheet
ods
Yes/Yes
A file format developed by Sun
Microsystems and OASIS. Readable by open
source spreadsheets, such as OpenOffice.
Portable Document
Format (PDF)
pdf
No/Yes
The file format originated by Adobe.
XML Paper
Specification
xps
No/Yes
Microsoft’s alternative to Adobe’s PDF.
 
Search JabSto ::




Custom Search