Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can I import selected excel data into Access

Status
Not open for further replies.

neerajam

Technical User
Mar 4, 2002
23
0
0
US
I am working on a project where all the data is in excel.
Working on creating an access database using this data. Depending on the table, I would like to import only selected data. Is it possible to do this. I know the other way is to import the whole file and then delete unwanted portions.

Thanks.
 
From my experience, when you import from excel, the import is done with a wizard. You are able to select which columns you wish to use or eliminate.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top