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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Import Excel file into Access Database

Status
Not open for further replies.

shimprince1

Technical User
Aug 23, 2007
1
US
I am trying to import an excel file into my database, but everytime I am prompted to indicated what table I want the Excel filed imported to and I select the table in my database all of the data previously imported into the table is overwritten. Is there a way to import the Excel file into my existing database table and indicate that I want the imported file to begin with the first empty record in my table.

I appreciate any help.
 
On the third screen of the import wizard, did you select "In an Existing Table"?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top