Importing information into Access 2007 from numerous other programs is easy. 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 existing data file.
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 import single or multiple SharePoint lists into an Access database, and even limit the data imported to a specific view of the SharePoint list.
You can create forms to send in Outlook e-mail, and automatically update an Access database with the responses.
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, such as tables, queries, forms, reports, pages, macros, and modules.
You can import data from certain versions of dBASE, Lotus 1-2-3, and Paradox into Access. You can choose to import information as it is and manipulate it in Access, or you can move it into some other program, such as Excel or Word, and manipulate it there before importing it into Access.
You can import a document saved in HTML format by another program into Access. If you attempt to import an HTML document into Access, it will parse the document and identify anything that looks like structured data. You can then look at what Access has found and decide whether to import it.
You can import XML files into Access. XML consists of data and a schema, which describes the structure of the data. Programs that export to XML might combine the data and schema in one file, or might create two files. If the program exports two separate files, you will need both files to import both the data and the structure into Access.
You can link your database to data in other programs, without actually importing the data into your database. This option can be useful if someone else maintains the other data, and you want to have the current information whenever it changes.
