Short answer for smaller projects:
If the barcode scanner is uploading to a .csv files, you can link directly to those files in Access. Under tables, click link tables, find your source file, and choose it.
You might:
-keep a library of links to these CSV files and build a merge query to...