Access won't let me import excel spreadsheet to an existing table

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

Guest

I can import an excel spreadsheet to a new table in access but it won't let
me do it to an existing table. What is different with an existing table?
 
The columns and column headings in the worksheet must exactly match the
fields and field names in the table, or you won't be able to import to
an existing table.

If the worksheet doesn't have column headings, Jet assigns default names
of F1, F2..., so the table must use the same names.

If you temporarily create a linked table to access the worksheet data,
you can then use an append query to move the data from the linked table
to your "real" table.
 
Back
Top