Microsoft Office Tutorials and References
In Depth Information
3. Click the Close button
on the Windows Explorer window title bar to close it
and to return to Access.
Trouble? If the Access window is not active on your screen, click the Microsoft
Access program button on the taskbar.
Sarah has a file containing customer billing addresses that she needs to add to the Pan-
orama database. Instead of typing these billing addresses into new records, she asks you
to import the data into the Panorama database.
Importing a CSV File as an Access Table
For most customers, the Address, City, State, and Zip fields in the tblCustomer table iden-
tify both the customer’s location and billing address, which is where Belmont Landscapes
sends the customer’s invoices. In a few cases, however, the billing address is different
from the location address; in addition, the company name used for billing purposes
might be different from the company name stored in the tblCustomer table. Sarah has
been maintaining an Excel workbook containing customer billing data, and she’s
exported the data to a CSV file. A CSV (comma-separated values) file is a text file in
which commas separate values, and each line is a record containing the same number of
values in the same positions.
Access can import data from a CSV file directly into a database table. Sarah’s CSV file
is named tblCustomerBilling, and you’ll import it as a table with the same name into the
Panorama database.
Importing a CSV File as an Access Table
| Reference Window
• Click the External Data tab on the Ribbon.
• In the Import group on the External Data tab, click the Text File button to open the Get
External Data - Text File dialog box.
• Click the Browse button in the dialog box, navigate to the location where the file to
import is stored, click the filename, and then click the Open button.
• Click the Import the source data into a new table in the current database option button,
and then click the OK button.
• In the Import Text Wizard dialog box, click the Delimited option button, and then click
the Next button.
• Make sure the Comma option button is selected. If appropriate, click the First Row Con-
tains Field Names check box to select it, and then click the Next button.
• For each field, select the column, type its field name, and select its data type, and then
click the Next button.
• Choose the appropriate option button to let Access create a primary key, to choose your
own primary key, or to avoid setting a primary key, click the Next button, type the table
name, and then click the Finish button.
Now you will import the tblCustomerBilling.csv file as an Access database table.
Search JabSto ::

Custom Search