Question: how to import data from excel to ms access 2007?
Answer: Prepare Your Data. ... , Create a New Access 2007 Database. ... , Begin the Excel Import Process. ... , Select the Source and Destination. ... , Select Column Headings. ... , Create Any Desired Indexes. ... , Select a Primary Key. ... , Name Your Table.