Imorting Excel Files by Records

[Guest]

I need to import several files from Excel to Access but I can not use the
TransferSpreadsheet function because I need to insert two new fields. One
field will be constant based on spreadhseet.name. The other will change
based on the value in column B. Can anyone help? Please.

 

[Nikos Yannacopoulos]

Vee,

You could definitely use automation to read row by row from Excel, but I
wouldn't bother; I would use plain and simple TransferSpreadsheet to
import into a buffer table, then run an append query on the buffer table
to add the two fields and append to the target table.

HTH,
Nikos