Can I import a single column to an existing table

J

JohnnyQuick

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
 
K

Ken Snell [MVP]

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

JohnnyQuick

JohnnyQuick said:
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
Click to expand...

Thx Ken that was helpful
 
Top