Import table info from excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top