Import table info from excel

S

SITCFanTN

I have an XLS file I'm trying to import into an existing table in Access I'm
in Access and select, File>Get External Data>Import. Then I select my
data.xls file. The Import Wizard dialog box displays and I select Next. The
Import Spreadsheet Wizard box displays saying "You can store your data in a
new or in an existing table" yet the "In and Existing Table option" is
disabled. I need to put this excel info in an existing table, I know I've
done it before so I don't understand what is causing the option for In an
existing table to be disabled. Any idea folks. Thanks so much for your help.
 
E

EeOr

Does your first row contain column headings? if not try putting headings
in and ticking the box that signafies this on the import wizard.

Jon
 
Top