Can I import a single column to an existing table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JohnnyQuick - 28 Jul 2005 18:19 GMT

I need to find out if I can import an Excel column into an existing Access
table. The table has defined columns already. Can I add another through
importing. Thx

Reply to this Message

Ken Snell [MVP] - 28 Jul 2005 18:28 GMT

No.... the table and the EXCEL worksheet must have the same number of
columns in terms of what you are importing (you can choose to not import a
column from the EXCEL worksheet, but you cannot use the import process to
add more fields to an existing table).

Import the column from the EXCEL file, then use an append query to copy the
data into your existing table.

Signature

Ken Snell
<MS ACCESS MVP>

>I need to find out if I can import an Excel column into an existing Access
> table. The table has defined columns already. Can I add another through
> importing. Thx

Reply to this Message

JohnnyQuick - 28 Jul 2005 18:58 GMT

> I need to find out if I can import an Excel column into an existing Access
> table. The table has defined columns already. Can I add another through
> importing. Thx

Thx Ken that was helpful

Reply to this Message