W
Westeral
I am able to export a table to an Excel Spreadsheet using the
transferSpreadsheet command. This application has to generate this
spreadsheet monthly to send to a central location with an identical database
where it will need to be imported from several locations in the state and
compiled for various statewide reports and statistics. I was testing the
import of the same spreadsheet I had just generated and received the error
message saying "Field 'F1' doesn't exist in destination table
"tblCaseReviews". Since this is a spreadsheet generated from this same table
it doesn't make sense to me. Am I missing something? F1 cell is just the
column heading on the spread sheet that is identical to the field name in the
Access table.
transferSpreadsheet command. This application has to generate this
spreadsheet monthly to send to a central location with an identical database
where it will need to be imported from several locations in the state and
compiled for various statewide reports and statistics. I was testing the
import of the same spreadsheet I had just generated and received the error
message saying "Field 'F1' doesn't exist in destination table
"tblCaseReviews". Since this is a spreadsheet generated from this same table
it doesn't make sense to me. Am I missing something? F1 cell is just the
column heading on the spread sheet that is identical to the field name in the
Access table.