excel importing data

To Import data from Excel to access follow the steps given below :

1. In Access open a database to which you want to
import data .
2. Goto File ->Get external Data-> Import.
3. Import dialog box will be opened.Select Files
of Type" as "Microsoft Excel".Select the file
you want to import and Click on "Import".
4. Import Spreadsheet Wizard will be displayed.In
the first wizard select a worksheet or
range of worksheets to be imported.
Click "Next".
5. Check the option "First Row Contains Column
Headings" if you want the first row in EXCEL
to be set as column headings (or) Field Names
in ACCESS TABLE. Click "Next".
6. Select the Option to store data "In the New
Table". Click "Next".
7. Set the "Field Options" as per your
requriements. Click "Next".
8. Choose the option "Let Access add Primary Key"
if you would like to set a primary key, (or)
select "No Primary Key". Click "Next".
9. Give the name of the "Table" your data to be
Imported.
10. Click on "Finish".

Hope this helps-:)

Regards,
Sherlock.
holmes@qsupport.com.