Import - Existing Table isn't showing as an option

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

Guest

I have created a donor tracking table for a non-profit. I created the table
by importing an excel spreadsheet into Access. If i try to import any new
records from excel, the option to import into an existing table isn't
available.

I'm running XP Professional and Access 2003

Any help would be great!

Marcy
 
The import wizard can only import data from Excel into an existing table
if the Excel data has column headings that match the field names in the
table.

One work-round is to link the additional data rather than try to import
it, and then use an append query to move it from the linked table into
the "real" one. Another is to use an append query that gets its data
from the Excel sheet and assigns the correct field names; the SQL syntax
is like this, with F1 etc. being the names assigned to the
(heading-less) Excel columns and Field1 etc. the names in the Access
table:

INSERT INTO MyTable
(Field1, Field2, Field3, Field4, Field5, Field6, Field7)
SELECT F1, F2, F3, F4, F5, F6, F7, F8, F9
FROM [Excel 8.0;Hdr=No;Database=C:\Folder\File.xls;].[Sheet1$];"
 
Back
Top