E
esi
I using the transferspreadsheet function to import a biweekly Excel file
into an access table. My questions are:
Does perform this function overwrite or append to the access table?
Is there a way to identify the Id nunmber of the Excel file I'm importing.
The access table has a field called ID# but it has to be manually updated
for every Excel record. Can I use an input box before using the
transferspreadsheet fuction that will assign the Id# from the input box to
each record I'm importing?
into an access table. My questions are:
Does perform this function overwrite or append to the access table?
Is there a way to identify the Id nunmber of the Excel file I'm importing.
The access table has a field called ID# but it has to be manually updated
for every Excel record. Can I use an input box before using the
transferspreadsheet fuction that will assign the Id# from the input box to
each record I'm importing?