Microsoft Access 2010 : Sharing Data with Other Applications - Importing ASCII Data

Import ASCII Data into Access

To import ASCII data into Access, follow these steps:

1.	Open the database into which you want to import a table.
2.	With Tables selected in the list of object types, right-click anywhere in the Navigation Pane and select Import from the context menu. (Alternatively, you can select Text File from the Import & Link group on the External Data tab of the Ribbon.) A flyout menu appears.
3.	Select Text File from the flyout menu. The Get External Data – Text File dialog appears (see Figure 1) Figure 1. The Get External Data – Text File dialog allows you to designate the location and name of the file that you want to import.
4.	Click Browse to locate the file you want to import.
5.	Indicate how and where you want to store the data in the current database and click OK. This launches the Import Text Wizard (see Figure 2). Figure 2. The Import Text Wizard allows you to designate important information about the format of the file you are importing.
6.	Select Delimited or Fixed Width, to designate the format of the file you want to import. Click Next.
7.	Indicate the delimiter that separates your fields (for instance, comma), the text qualifier, select or deselect First Row Contains Field Names, as appropriate, and then click Next. The wizard appears as in Figure 3. Figure 3. The wizard allows you to supply field names and other important information about the fields you are importing.
8.	Type the field name in the Field Name text box.
9.	Select whether you want Access to create an index for the field.
10.	Change the data type, if desired.
11.	Repeat steps 8–10, as appropriate, and then click Next.
12.	If your data has a column that is appropriate for the primary key, select Choose My Own Primary Key. Otherwise, select Let Access Add Primary Key.
13.	If you opted to choose your own primary key, select the field from the drop-down box that you want Access to use as the primary key, and then click Next.
14.	Type the table name in the Import to Table text box.
15.	Click Finish, and then click OK.

When working with ASCII data, you should be aware of a few things that can save you lots of time and effort in working with the imported data, as follows:

• After you import a table, you should open it and view its data. You might want to modify some of the field types to make them the appropriate Access data types. For example, the table you imported from might not have had a currency type.

• You can click the Advanced button anytime in the wizard to change the import specifications for each field (see Figure 4).

  Figure 4. The Advanced button enables you to change the import specifications for each field.