How to Populate a Database Using MS Access 2007

You can import Access data from many sources.

When you create a new database in Access 2007, you do not necessarily have to type all the data in by hand. If the information you need to populate the database exists in another electronic format, you can import that data directly into your new Access 2007 tables. The ability to import external data can save you many hours of work and help you avoid the keying errors that could harm the integrity of the database.

Things You'll Need

• Source file (Microsoft Excel databases, CSV files, text files, etc.)
• Microsoft Access 2007

Instructions

1. Open the Access database you want to work with. Click the "External Data" tab on the Import group.

2. Click "Browse" when the Get External Data dialog box opens. Browse to the file you identified earlier and click "Open."

3. Select the "Import the source data into a new table" option and click "OK." Click "Next" to start importing your data.

4. Review the list of field names and make any changes you wish. Access uses the existing field names from the source file as the default, but you can choose new names if you wish.

5. Click "Finish" to complete importing the data from the source file. Double-click the table to review the imported data.

References

• Microsoft Office: Get External Data