Importing an Excel Sheet

[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?

 

[John]

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.