Importing an Excel Sheet

  • Thread starter Thread starter DaveB
  • Start date Start date
D

DaveB

I'm having trouble importing an Excel Sheet. I Imported
one with most of the information that the new one has,
but I left out an important field so I deleted it and
then tried to import the new excel sheet and I get and
error message. It says," An error occured trying to
import file 'C:\Documents and Settings\Me\My Documents\A
Better Plumbing Company\Arco.xls.' The file was not
imported." Any ideas what I need to do to get this file
imported?
 
If you are importing data to an existing table, make sure
the column headings in Excel match the Fields in the
Access Table you are importing to. If there is a spelling
error or if the there are more columns then fields the
import will fail.

I you import to a new table the import should work, just
follow the instructions when importing.
 
Back
Top