Imorting Excel Files by Records

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

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.
 
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
 
Back
Top