Sharing Data

Access is much more than just a database.  It's part of the best suite of computer software on the market.  Access, Word, and Excel all work well together, which means data that's entered in one application can be used in another.

Note |

You can turn off the AutoCorrect feature for individual form controls.  Open the form in design view and double-click the control in question.  Then, set the control's AllowAutoCorrect property to No.

More Compatible Formats

Access can talk to non-Office applications.  Access can import or link to all of the following formats:

• Any Access database files (.mdb, .adp, .mdw, .mda, .mde)
• Excel spreadsheet files (.xls)
• dBASE III, dBASE IV, and dBASE V database files (.dbf)
• Paradox 3.x, 4.x, and 5.x database files (.db)
• Lotus 1-2-3 spreadsheet files (.wk*, .wj*)
• Delimited text files
• Fixed-width text files
• Exchange and Outlook files
• HTML files (.html, .htm)
• ODBC database files
• XML documents (*.xml, *.xsd)