adding a field to access db thru import

[ruthsieg]

I am using a saved import to move data from my excel spreadsheet into my
access table. I would like to have one additional field in my table which
doesn't exist in my spreadsheet. (It will initially have no values in the
field). Can I accomplish this during my import process? If not, what is the
most automated method for creating this additional field?
[I can obviously add the column in excel and have it imported, but I want to
avoid any more manual steps].

 

[Klatuu]

Rather than import the spreadsheet directly, create your table in Access as a
permanent table that includes the field names and data types you need to
accept the Excel data and add the additional field you need.

Now, instead of doing an import, Use the TransferSpreadsheet to link to the
file.
Then run an append query that will copy the data from the spreadsheet into
the table, then drop the link to the spreadsheet.