How to UN-check greyed-out "First Row Contains Column Headings" bo

C

chamuel

How to UN-check greyed-out "First Row Contains Column Headings" box ?

Hi. Can anyone help with this beginner's question?

I want to import a very simple Excel sheet (2007) into Access (2007).

The Excel sheet has 2 columns. It has NO "column headings"--just data.
Column A = text
Column B = numbers

When I use the Access import wizard, the "First Row Contains Column
Headings" field is CHECKED and *GREYED-OUT* (so I can not un-check it).

When I try to finish the wizard, it rejects all the records "due to key
violations".

I think this is probably because it is assume Column A is "Column Headings".

So . . . how can I tell the wizard to UN-check the "First Row Contains
Column Headings" field??
 

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

Top