copy from excel to access

  • Thread starter enrico via AccessMonster.com
  • Start date
E

enrico via AccessMonster.com

can you copy hundreds of fields from a column in excel to a column in an
access table?
 
J

Jack Cannon

I believe that your question concerns copying hundreds of cells from a column
in excel to a field in an access table? If so Yes. Use the Import function.

File / Get External Data / Import

This will create a new table with a single field corresponding to the Excel
column.

Jack Cannon
 
E

enrico via AccessMonster.com

is there any other way that you won't import so that you won't create a new
table in access?
 
Top