Import table info from excel

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Import & Link section grayed out MS Access 2010 1
import data from excel 2003 to a table in an existing database 2
Add data from Excel to Access 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import and append a column from excel to an existing db 13
Access Importing csv daily files into access 2007 1
importing data from excel to access 2000 1
Access Subscript out of range when importing into access 2010 from excel 0

Top