Can I import a single column to an existing table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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