Techniques for successfully importing Excel data into Access - The Diigo Meta page

• 10 Jul 08
  

  Claire

  database

  • You should eliminate small inconsistencies between these related sheets by deleting unnecessary columns or rearranging data. Be sure to check for hidden columns—even one inconsistent column will generate an error during the import process.
  • Sometimes, you can’t delete an inconsistent column because you need to import that data as well. When this is the case, copy the data to another sheet or range, delete the original data and column and then import the copied data into an individual table.
  • A failure is defined as a data type that’s converted incorrectly or a value that isn’t imported. Incorrectly converted data types are a problem that Access won’t identify, so they can be troublesome. Import errors—values that Access can’t import—are logged in a special table during the import process. Use this table to find those errors. If there are numerous errors, you may have to tweak the Excel data and import again. Or you may choose to manually enter the values yourself, if there are only a few.
  • Resolve any known data type conflicts before importing.

  2 more annotations...

• 25 Jun 08
  

  Tim Tabor

  ProgrammingAccess ProgrammingExcel ProgrammingDb

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.