Import Excel spreadsheet into Access (2007/2010)
Importing a spreadsheet into Access 2007 (also works with 2010). Note, zip codes can be very problematic. it is suggested that a CSV file be used so that you don't lose the 0's, esp. if you're in New England where zips start with a 0, ie 06460. to do this, you'd have to do a save as in Excel.