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.