Microsoft Office Tutorials and References
In Depth Information
To import the CSV file as an Access table:
1. Click the External Data tab on the Ribbon, and then in the Import group on the
External Data tab, click the Text File button (with the ScreenTip “Import text file”)
to open the Get External Data - Text File dialog box.
2. Click the Browse button, navigate to and open the Level.02\Tutorial folder, click
tblCustomerBilling , click the Open button, and then click the Import the source
data into a new table in the current database option button. The selected path
and filename appears in the File name text box. See Figure 8-4.
Get External Data - Text File dialog box
sel e cted CSV filename (your
path might be different)
import optio ns
for a CSV file
The dialog box provides options for importing the data into a new table in the
database, appending a copy of the data to an existing table in the database, and
linking to the source data. In the future, Sarah wants to maintain the customer
billing data in the Panorama database, instead of using her Excel workbook, so
you’ll import the data into a new table.
3. Click the OK button to open the first Import Text Wizard dialog box, in which you
designate how to identify the separation between field values in each line in the
source data. The choices are the use of commas, tabs, or another character to
separate, or delimit, the values, or the use of fixed width columns with spaces
between each column. The wizard has correctly identified that values are delimited
4. Click the Next button to open the second Import Text Wizard dialog box, in which
you verify the delimiter for values in each line. See Figure 8-5.