I am building a database in Access 2010 that will be used for tracking the revenue cycle for invoices. Each month we will be importing 4 Excel spreadsheets, each into a separate corresponding Access tables. For example, data from the Unbilled worksheet will be imported into tblUnbilled, and the Category for each record will be "Unbilled".
The existing table already contains a field called Category, and I need it to populate that field for each newly imported record because the field will not exist in the spreadsheet I am importing. I know I could add the field in the Excel worksheet before importing it, but I want my users to have to do as little data scrubbing as possible when I turn it over to them.
Is there a way I can pre-set a field's value to the specific category? I could set up an Update query and have it run after the import, but I'd rather avoid that if there is an easier way to have this field automatically populated for me.
Any help will be appreciated.