Microsoft Office Tutorials and References
In Depth Information
Importing data from Excel
Importing data from Excel
When importing data from Excel, if you have only one
worksheet and no named ranges defined, the wizard does not
prompt you to make any additional decisions (as described
shortly in step 5). But if you have either multiple worksheets or
one or more ranges defined in a single worksheet or in multiple
worksheets, you are prompted to select either a worksheet or a
named range.
When importing data, you will also find that Access makes a
best assessment of the appropriate data type to use for each
column, but you can review and change the choice of data type
before importing the data.
1
Import data from Excel
1 Click Excel in the Import & Link group on the External Data tab.
2 Keep the default selection to import the source data into a new
table in the current database.
3 Browse to locate the Excel file. Select the file and click Open.
4 Click OK.
5
Select the required worksheet from which to import the data, and
click Next.
2
(continued on the next page)
4
3
5
TIP The wizard also offers an option to directly append data
into an existing table. However, it is often better to import data
into a temporary staging table and then use the techniques described
in Section 7, “Modifying data using queries,” starting on page 117,
using action queries to transfer the data into your main tables after
checking the data.
Search JabSto ::




Custom Search