I had to try a few things but finally found a way. Not smart, but it would work. You can do this with Base. I’ll add a very simple prototype. The .odb file is LO Base 22.214.171.124 and db type is HSQLDB. Field SN is the primary key. With a Laser Barcode Scanner type MK-1500 I’m able to scan barcodes endless forward that way you are looking for. At least in Windows 7, because my Scanner is not functional under Windows 10 (should, but isn’t).
Once this is done, there seems to be only one real tiny path to export a table from Base to Calc via Clipboard (found no other export option). But there is a drawback of how numbers are recognised when inserting into Calc: Right-Click the table in Base,
copy, move to Calc, Right-Click cell, (don’t know exact in english)
Insert contents, on fly-out again
Insert contents, choose
HyperText Markup. This inserts the data as text. Other options would result in number conversion and displaying them in scientific notation. From Calc you could export again into other data formats.
Maybe you have to figure out some more details until your workflow is operational. Good luck.
Auto PN SN Scan.odb
Auto PN SN Scan.ods