Importing Information from a dBASE File


Importing information from databases created in programs other than Access is usually an all-or-nothing situation, and quite often, what you get isn't in the exact format you need. You might find, for example, that transaction records include redundant information, such as the name of the product or purchaser, in every record. A database containing information about people might include the full name and address in one field, when you would prefer to have separate fields for the first name, last name, street address, and so on. 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 Microsoft Office Word, and manipulate it there before importing it into Access.

Access can import data from the following versions of dBASE, Paradox, and Lotus 1-2-3:

Program

Versions

dBASE

III, IV, 5, and 7

Paradox

3, 4, 5, 8

Lotus 1-2-3

WKS, WK1, WK3, WK4


In this exercise, you will import information from a dBASE file into an existing table in an Access database. The process of importing the other file types is essentially the same.

USE the 09_ImportDbase database and the 09_Ship dBase file. These practice files are located in the Chapter03 subfolder under SBS_Access2007.

OPEN the 09_ImportDbase database.


1.

On the External Data tab, in the Import group, in the More list, click dBASE File.

The Get External Data wizard starts.

2.

On the Select the source and destination of the data page, click the Browse button.

3.

In the File Open dialog box, navigate to your Documents\MSP\SBS_Access2007\Chapter03 folder, click the 09_Ship file, and then click Open.

4.

Select the Import the source data into a new table in the current database option, and then click OK.

Access imports the data and creates the 09_Ship table.

5.

On the Save Import Steps page, click Close.

6.

Open the 09_Ship table to confirm that five records were imported properly.

CLOSE the 09_ImportDbase database.




MicrosoftR Office AccessT 2007 Step by Step
MicrosoftR Office AccessT 2007 Step by Step
ISBN: N/A
EAN: N/A
Year: 2004
Pages: 127

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net