Microsoft® Office Access 2003 Step by Step

Key Points

• Access 2003 makes it easy to import information in numerous formats from other programs. If the information is still being actively maintained in another program and you want to bring it into Access to work with it, you can link your Access database to the information in its original program.

• You can import entire Excel worksheets, or a named range from a worksheet into a new table or an existing table. You can also import specific fields from a worksheet or range.

• You can use the Import Wizard to import delimited and fixed-width text files into your Access database.

• You can easily import one or more of the standard Access objects: tables, queries, forms, reports, pages, macros, and modules.

• You can import data from certain versions of ...