An American Addiction Centers Resource

New to the Forums?Join or

Barcode Scan Into SQL Server

Discussion in 'Share Your Story Here' started by CholeBur, Mar 20, 2023.

  1. CholeBur

    CholeBur Member

    We have an Access front end with a SQL Server backend. We have inventory that we need to scan and keep track of. Is there a way to scan barcodes into a SQL Server table? I'm not sure if it would be better to use a tablet or phone scan or something else. We are looking to scan the inventory to the backend SQL table and then be able to view it in MS Access front end and track inventory. Any ideas on the best way to do this is appreciated.
  2. nieprophsono

    nieprophsono Active Contributor

    There are two basic types of scanners: Those that scan and store into their own memory and those that scan and store to some memory over wifi or physical connection.
  3. PiersBall

    PiersBall Member

    "Hey! I see it's a bit old discussion, but I would like to chime in. One option is to use a mobile device such as a tablet or phone with a barcode scanner app. You can then connect the device to your SQL Server database and use an app or web interface to scan and input the inventory data directly into the database.
    Another option is to use a barcode scanner connected to a computer and a program such as Microsoft Access to input the inventory data into the SQL Server database. Or you could use the alternative app, like . I hope that helps you. "