Import contacts from an Outlook address book
Access and Outlook are both excellent programs for managing your personal and business contacts. As a result, you might want to import contact data from Outlook 2007 into Access 2007. However, the Outlook import feature in Access 2007 cannot directly import data from the Outlook 2007 file format, and Outlook 2007 cannot directly export data to an Access 2007 database. Fortunately, it is easy to export Outlook contacts as a text file, and then import that file into Access 2007. Learn: * Import or link to Outlook contacts by using the Exchange/Outlook Wizard, * Import contacts by using a text file, * Import contacts by using the Contact Management Database template.

---

Import an Access 95 database into an Access 2007 file
If you use an existing database in the Access 95 format (.mdb), you can import tables, queries, and macros from that database into a Microsoft Office Access 2007 database (.accdb). You can also import forms and reports that do not employ Microsoft Visual Basic for Applications (VBA) code. To import forms and reports that contain VBA code (and also modules), first convert your Access 95 database to the Access 2002 - 2003 or Access 2000 file format by using Microsoft Office Access 2003, Access 2002, or Access 2000, and then use Access 2007 to convert that file to the Access 2007 file format. What do you want to do? * Import data from an Access 95 database * Convert an Access 95 database by using Access 2003, Access 2002, or Access 2000

---

Export contacts to an Outlook address book
Access and Outlook are both excellent programs for managing your personal and business contacts. As a result, you might find yourself wanting to export contact data from Access to Outlook. However, Access 2007 cannot directly export data to the Outlook file format, nor can Outlook 2007 directly import a table from an Access 2007 database. Fortunately, it is easy to export an Access table or query as a text file, and then import that file into Outlook 2007.

---

TransferText Macro Action
You can use the TransferText action to import or export text between the current Microsoft Office Access 2007 database (.mdb or .accdb) or Access project (.adp) and a text file. You can also link the data in a text file to the current Access database. With a linked text file, you can view the text data with Access while still allowing complete access to the data from your word processing program. You can also import from, export to, and link to a table or list in an HTML file (*.html).

---

Import or link to data in a text file
You can bring data from a text file into Microsoft Office Access 2007 in two ways. If you want a copy of the data that you can edit within Access, import the file into a new or existing table by using the Import Text Wizard. If you simply want to view the latest source data within Access for richer querying and reporting, create a link to the text file in your database by using the Link Text Wizard. This article explains how to import and link to a text file by using these wizards. In this article * About text files and supported formats * Import data from a text file * Troubleshoot missing or incorrect values in an imported table * Link to a text file * Troubleshoot #Num! and incorrect values in a linked table

---

Access Tips
Adding the Database Name to a Report in Access, Automatically Compact and Repair Access Databases, Change the Default Working Folder in Access, Combining Text from Two Fields in Access, Create a Vertical Control in Access, Define a Default Field in an Access Database, Deleting Duplicate Records in Access, Display Tabbed Documents in Access 2007, Displaying Highest or Lowest Values in an Access Query's Results, Import Access Tables into Excel, Insert Time/Date in Excel or Access, Navigation Pane in Access 2007, Number Entries in an Access Report, Report Layout View in Access 2007, Techniques for Creating Forms and Reports in Access, Upgrading to Access 2007, Using Validation Rules to Restrict Data in Microsoft Access

---

Link an Access 2007 database to a database that contains data access pages
A data access page is a Web page that is designed to let you view and work with data from the Internet or an intranet. This data is typically stored in an Access database. The ability to create, modify, or import data access pages is no longer supported in Microsoft Office Access 2007. However, you can still use Access 2007 to work with databases that contain data access pages.

---

How to Import Shapefiles into Microsoft Access
How to Import Shapefiles into Microsoft Access. This tutorial demonstrates how to import an ESRI shapefile into an Access database using the... (PDF file, install Acrobat Reader to read this file)

---

Access 2007 Error - when I try to import a text file
I am having some issues with Access 2007. When I try to import a text file into a table using a predefined spec, the routine will run for a while and then error out with the message "the search key was not found in an record". Any ideas on what this is and how I can fix it??

---

Convert a database to the Access 2007 file format
You can convert a database that was created by using Microsoft Office Access 2003, Access 2002, Access 2000, or Access 97 to the new Microsoft Office Access 2007 file format. You should use the new file format whenever possible because it supports new features, such as multivalued fields and attachments. However, a database in the new Access 2007 file format (.accdb) cannot be opened or linked to with earlier versions of Access, and the new format no longer supports replication or user-level security. If you need to use your Access 2007 database with earlier versions of Access, or if you need to use replication or user-level security, you must use a file format from an earlier version.

---

Change the default file format
When you create a new, blank database in Microsoft Office Access 2007, you are prompted to provide a name for the database file. By default, the file is given the ".accdb" extension - it is created in the Office Access 2007 format and is not readable by earlier versions of Access. In some cases, you may prefer to create files in an earlier Access format. In Office Access 2007, you have the option of creating files in either the Access 2000 format or the Access 2002-2003 format (both with the extension ".mdb"). Then, when you create a new database file, the resulting file is created in the earlier Access format and can be shared with others who use that version of Access. This can be helpful if you have upgraded to Office Access 2007 but you share files with others who have not.

---

What happened to data access pages?
A data access page is a Web page that is designed to let you view and work with data from the Internet or an intranet. This data is typically stored in an Access database. The ability to create, modify, or import data access pages is no longer supported in Microsoft Office Access 2007. However, you can still use Access 2007 to work with databases that contain data access pages. * Use Access 2007 to work with a database that contains data access pages * Alternatives to data access pages

---

Help secure an Access 2007 database
This article explains how to help keep your Microsoft Office Access 2007 databases more secure. It explains the concepts that you must understand before you can use the Office Access 2007 security features properly and how to use the tools that Access provides for helping to secure a database. In this article * What's new in Office Access 2007 security * Use an Office Access 2007 database in a trusted location * Package, sign, and distribute an Office Access 2007 database * Enable disabled content when you open a database * Use a database password to encrypt an Office Access 2007 database * How security works with databases from earlier versions of Access opened in Office Access 2007 * Run unsafe expressions (disable sandbox mode)

---

TransferSpreadsheet Macro Action
You can use the TransferSpreadsheet action to import or export data between the current Access database (.mdb or .accdb) or Access project (.adp) and a spreadsheet file. You can also link the data in a Microsoft Office Excel 2007 spreadsheet to the current Microsoft Office Access 2007 database. With a linked spreadsheet, you can view and edit the spreadsheet data with Access while still allowing complete access to the data from your Excel spreadsheet program. You can also link to data in a Lotus 1-2-3 spreadsheet file, but this data is read-only in Access.

---

Convert an Access 2007 database to an earlier file format
If you created a database in the Microsoft Office Access 2007 (.accdb) file format, but you want to share the database with people who are using earlier versions of Access, in most cases, you can convert the database to an earlier file format by using the Save As command. This article provides the steps for converting a database to an earlier file format and discusses some of the factors that prevent you from converting a database. In this article: * Convert an Access 2007 database to an earlier file format * Factors that prevent conversion to an earlier file format

---

Microsoft Access File Format
The newest version of Microsoft Access marks the introduction of a new file format which uses the file extension of .accdb. In addition to this new format, however, Microsoft Access 2007 continues to provide support for many of the file formats used in earlier versions of the database program. Even so, it is recommended that users of Access 2007 use the new .accdb file format whenever possible, in order to take advantage of the many new features and benefits it provides. The new .accdb file format includes a number of new product enhancements and features. When a new database is created using Access 2007, the file is saved as an .accdb file by default. This new file format should be used whenever possible since the format supports a number of new features and benefits, including multiple value fields and the addition of attachments in various formats.

---

Secure Microsoft Access Passwords and Encryption in Access 2007
Hello Microsoft Access fans and skeptics. In this article, I am going to describe how you can improve on what already is a very significant security improvement in Access 2007, database encryption. Microsoft Access 2007 introduced a new file format for storing Access database information. This file format can be identified by any file that ends with .ACCDB. Whilst Microsoft Access 2007 still supports the file type of .MDB, the future of Access is going to be built around the .ACCDB format. One of the most significant changes with the .ACCDB format is a new method of encryption that is based around the database password. This change is a very significant security improvement because encrypted ACCDB databases are (in theory) strong enough that they can only be cracked using very computer intensive brute-force password recovery. Of course, as with all security, if lots of people do things the same way the risk is far higher that someone will work out how to breach the security. This definitely will apply to encrypting an Access 2007 database because the default encryption algorithm used is RC4 with a 40-bit key, one that is not as strong as it could be. In this article I am going to show you how to make your password encrypted database more secure than the standard ACCDB encryption.

---

Which file format should I use in Access 2007?
Microsoft Office Access 2007 introduces a new file format that uses the .accdb file extension. In addition, Office Access 2007 continues to provide some support for the file format used in earlier versions of Access. This article explains why you should use the new file format whenever possible, and why you might need to use the earlier version file format in some instances. You will also learn explicitly how to convert a database to the new file format. In this article * The new file format (.accdb) * The earlier version file format (.mdb) * Converting to the new file format

---

Microsoft Access and HTML
Importing an HTML File: If you have a table on a web page and the table is well structured for a database, you can use it as a table of your database. That is, you can import it in Microsoft Access. Like a normal text file, a typical HTML document can contain anything. This means that you should not attempt to import just any HTML file into your database.

---

How to Create a Microsoft Access Macro to Import Information from a Text (.txt) File
Macros are operations used in Microsoft Access in order to automate functions in databases. They can be used to open reports, run queries, update the databases and import from various file formats such as Excel (.xls), database, (.dbf), and text (.txt). This article will explain, in a step-by-step format, how to import information from a text file, format the information for Access, and create the macro so each step will not need to be created every day. This will save you time and put some of the database operations into the hands of the end-users and freeing you to do other things. Prior to creating the macro, the creation and saving of the import specification will be explained.

---

Import menus and toolbars
You can import custom menus and toolbars from a Microsoft Access database or Microsoft Access project. However, Access won't import a toolbar, menu bar, or shortcut menu if it has the same name as one in the Access data file you're importing to - you must rename it before importing.

---

TransferDatabase Macro Action
You can use the TransferDatabase action to import or export data between the current Access database (.mdb or .accdb) or Access project (.adp) and another database. For Microsoft Office Access 2007 databases, you can also link a table to the current Access database from another database. With a linked table, you have access to the table's data while the table itself remains in the other database.

---

Import or link to data in another Access database
You can bring data from one Access database into another in many ways. Copying and pasting is the simplest method, but importing and linking offer you better control and flexibility over the data that you bring, and over how you bring that data into the destination database. This article explains how to import or link to data in another Access database. What do you want to do? * Understand importing and linking to data from another Access database * Import data from another Access database * Link to data in another Access database

---

Schedule an import or export operation
You can streamline an import and export operation you regularly use in Microsoft Office Access 2007 by creating a specification for it and then creating a task in Microsoft Office Outlook 2007 to remind you to run the specification. For added convenience, the Office Outlook 2007 task contains a button that you can use to run the operation without opening the Access database. To use this feature, Office Outlook 2007 must be installed and configured on your computer. What do you want to do? * Create and schedule a new import or export specification * Schedule an existing import or export specification * Run a scheduled import or export specification

---

Understanding and working with Access Projects
An Access 2007 project is an .adp file (Access file) which provides a direct connection a Microsoft SQL Server database through the OLE DB component architecture. An Access 2007 project can be connected to a local and/or remove SQL Server Database or a local installation of the SQL Server Desktop engine.

---

Excel to Access Converter Utility program
This utility program allows you to convert an Excel spreadsheet file which contains 'flat-file' data into one or more tables in an Access database. The program creates primary and foreign keys in the tables so that 'One to Many' or even 'Many to Many' related tables can be created automatically. You just import the Excel file into the program, create a template which tells the program which columns in the spreadsheet should be copied to which fields in which tables, click a button and the program will extract the data into a series of separate tables which can then be exported to a new database via .csv files. The program can also be used to create properly 'normalised' tables from data in MS Works or any other database by first exporting the data to an Excel spreadsheet (or .csv file which can then be imported into Excel). Full instructions are included. Version. This version runs under Access 2003 (not tried it on Access 2007).

---

Import or link to data in an Excel workbook
You can bring the data from a Microsoft Office Excel 2007 workbook into Microsoft Office Access 2007 in many ways. You can copy data from an open worksheet and paste it into an Access datasheet, import a worksheet into a new or existing table, or link to a worksheet from an Access database. This topic explains in detail how to import or link to Excel data from Access. What do you want to do? * Understand importing data from Excel * Import data from Excel * Troubleshoot missing or incorrect values * Link to data in Excel * Troubleshoot #Num! and other incorrect values in a linked table

---

Demo: Up to speed with Access 2007
Microsoft Office Access 2007 brings you a new look and new features designed to help you get your work done more easily than ever. You'll see differences right away, starting with the Getting Started with Microsoft Office Access page where you can open a blank or existing database, download a pre-built database template, and check out the offerings on Microsoft Office Online. Watch the demo for an introduction to Office Access 2007. You'll also hear about new file formats, and see how to work with files from previous versions of Access.

---

My PivotTable and Chart controls don't work in Access 2007
When you open a Microsoft Office Access 2003 or earlier Microsoft Access file format database in Access 2007, one of the following messages appears: * Your Microsoft Office Access database or project contains a missing or broken reference to the file '0WC10.DLL' version 1.0. * Your Microsoft Office Access database or project contains a missing or broken reference to the file '0WC11.DLL' version 1.0. Access 2007 opens the database file, but any Microsoft Office PivotTable controls or Microsoft Office Chart controls that are contained on forms, reports, or data access pages do not work. In addition, Access might show the message "There is no object in this control" when you open an object that contains a PivotTable control or Chart control.

---

Create a new database
Microsoft Office Access 2007 features a number of improvements that make the process of creating a new database easier. Even if you have created databases before, it is likely that you will appreciate these features for their ability to speed up the creation process. This article covers the basic process of starting Office Access 2007 and creating a database, either by using a template or by creating your own tables, forms, reports, and other database objects. It also details a few techniques that you can use to get information into your new database. What do you want to do? * Get to know the Getting Started with Microsoft Office Access page * Create a database by using a template * Create a database without using a template * Copy data from another source into an Access table * Import, append, or link to data from another source * Open an existing Access database * Create a custom blank template

---

Introduction to the Access 2007 file format
Microsoft Office Access 2007 creates files in a new file format that cannot be opened with earlier versions of Access. This article describes the new features of the Office Access 2007 file format, reviews some issues that arise when you convert to earlier file formats, and summarizes how some related file types have changed from earlier versions. In this article: * New features of the Access 2007 file format * Conversion to earlier file formats * File types * Linked tables * Replication

---

The Power of Import Specifications in Access 2007
One of the most powerful features contained within the Microsoft Access database program is the ability to create import and export specifications. These specifications are important for a number of reasons, but one of the most powerful is that it allows for the importation and exportation of data to be automated and scheduled.

---

Get to know Access 2007
When your data works for you, that's great. When you have to work on your data, that's not so good. For convenient, reliable data management, get to know Access 2007. It puts you in charge. After completing this course you will be able to: 1) Explain the benefits of Access 2007 compared to workbooks or lists. 2) Find and download an Access 2007 database template. 3) Identify the main parts of a database.

---

Access 2007 Deciding Whether to Change Database Formats
The newest version of Access, Microsoft Access 2007, marks the end of the old familiar .mdb file format, replaced with the .accdb file extension. It is important for Access users to become familiar with the new format in order to be able to make an informed decision of how, and whether, to transition older databases into the new .accdb format.

---

Set or change Access 2003 user-level security in Access 2007
If you created a database in a previous version of Access and you applied user-level security to that database, those security settings remain in place when you open that file in Microsoft Office Access 2007. In addition, you can start the security tools provided by Microsoft Office Access 2003 - the User-Level Security Wizard and the various user and group permission dialog boxes - from Office Access 2007. This article explains how the Access 2003 security features work, and it explains how to start and use them in Access 2007.

---

Introduction to the Access 2007 Developer Extensions and Runtime
With the release of Microsoft Office Access 2007, the Access 2007 Developer Extensions and the Access 2007 Runtime are available as free downloads. These utilities provide database developers with tools to package and deploy a database, create database templates, and integrate a database with source code control systems, such as Microsoft Visual SourceSafe.

---

Understanding the Field and File Formats of Access 2007
One of the most unique changes in the newest version of Microsoft Access, Microsoft Access 2007, is the introduction of new field formats. Most database programs, including all previous versions of Access, allowed only a single value to be stored within each field, but Access 2007 allows users to store multiple values in each field, in effect creating a many to many relationship within the field itself, while hiding the details of the implementation using system tables.

---

Import or link data and objects
Learn how to import or link data and object from: another Access file, a text file, a spreadsheet, a Web Page, Windows SharePoint Services, SQL or another ODBC data source, a mail program, another database, a data access page, data in XML and more.

---

Creating a Database using Access 2007
Access 2007 51-page tutorial in .doc file format (MS Word document).

---

Access File Formats: ACCDB vs MDB
The release of Access 2007 brings a new file format. The MDB database files we've known for over a decade are now slated to become historical relics. While Access 2007 continues to support MDB databases for backwards compatibility purposes, Microsoft has now introduced the new ACCDB file format as the future standard. Wondering if you should begin using the ACCDB format?

---