Microsoft Access also allows you to import data from an Excel Worksheet. You will find that the process is very similar to importing a text file. When importing an Excel file, you even have the option of bringing in either an entire worksheet or a specific named range.
Once you have chosen the Excel file that you want to import, the Import Spreadsheet Wizard will step you through the process of importing the worksheet file. Before proceeding however, you will want to ensure that the data in the spreadsheet is arranged in a correct tabular format. If you are appending your data to an existing table, you will want to set the data types the same as the table into which you are importing.
To Import a File from Excel into Access
1. Click the External Data tab on the Ribbon.
2. Click the Excel button on the Import group on the Ribbon.
3. Click the Browse button and then navigate to the folder that contains the Excel file you want to import.
4. Select the file and then click the Open button.
5. If you want to import your data to an existing table:
a. Select the radio button next to Append a copy of the records to the table:
b. Choose the table into which you want to import the text file from the drop-down list.
c. Click OK.
d. If you are importing an entire worksheet, click the Show Worksheets radio button and select the worksheet to import. If you are importing a range within a worksheet, click the Show Named Ranges radio button and select the range to import.
e. Click Next.
f. Click Finish
6. If you want to import your data to a new table:
a. Click the radio button next to Import the source data into a new table in the current database.
b. Click OK.
c. If you are importing an entire worksheet, click the Show Worksheets radio button and select the worksheet to import. If you are importing a range within a worksheet, click the Show Named Ranges radio button and select the range to import.
d. If the first row of the text field contains the names of the fields, select the First Row Contains Field Names box.
e. Click the bar above each field to make any field name, data type or indexing changes.
f. Click the do not import field box if you do not wish to import a particular field.
g. Choose the desired primary key option. If choosing your own primary key, select the field for which you want to define a primary key from the drop-down list.
h. Click Finish.
Similar Posts:
- Restoring Outlook Data from a Backup
- Mail Merge in Word 2007 Part 2: Selecting the Data Source
- Creating a Table in Excel
- Remove Spaces from Imported Excel Data
- Creating an XML Query in Excel
- Using the VLOOKUP Function in Excel
- Creating a Refreshable Web Query in Excel
Comments on this entry are closed.