Data From Excel to Acess

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Shaw - 28 May 2004 17:46 GMT

When I import data from Excel to Access I can do this to a new table. No problem will sto

However, the option to import data from Excel to an existing table is always greyed out

What my doing wrong?

Reply to this Message

tina - 28 May 2004 19:38 GMT

in testing an Excel import in A2003 (A2000 format db), i found that if you
do not checkmark the box next to "First Row Contains Column Headings" on the
second "page" of the Import Wizard, then the Existing Table option is indeed
greyed out. if you go back and checkmark that box, however, the option
becomes available.

hth

> When I import data from Excel to Access I can do this to a new table. No problem will stop
>
> However, the option to import data from Excel to an existing table is always greyed out.
>
> What my doing wrong?

Reply to this Message

John Nurick - 28 May 2004 20:53 GMT

Hi David,

If you want to import to an existing table, the first row of the range
in Excel must contain the field names and you must select this option in
the Spreadsheet Import Wizard.

>When I import data from Excel to Access I can do this to a new table. No problem will stop
>
>However, the option to import data from Excel to an existing table is always greyed out.
>
>What my doing wrong?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message