# Easy way to enter Product Data from Access Database to Sambapos **URL:** \ **Category:** V5 Question\ **Created:** [May 20, 2018, 3:29am UTC](https://forum.sambapos.com/t/easy-way-to-enter-product-data-from-access-database-to-sambapos/17497 "2018-05-20T03:29:24Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![adam100](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/a/f4b2a3/32.png) [@adam100](https://forum.sambapos.com/u/adam100)\ **Post date:** [May 20, 2018, 3:29am UTC](https://forum.sambapos.com/t/easy-way-to-enter-product-data-from-access-database-to-sambapos/17497/1 "2018-05-20T03:29:24Z")
Hello all. I am in the process of building a second Sambapos system in our retail/catering side of the business. We have Sambapos running nicely in our restaurant and want to use it in our deli/convenience store. Since it is a different department and business altogether, we will buy a new license for it and build a new database. My question is, is there an easy way to import, or copy and paste, or even enter data into sambapos from our current POS system, Regit POS by American Precision Instruments? They use a basic Microsoft Access Database for their software and the product data (UPC, Product Name, and Price) are in spreadsheet form. Is there an easier way to key in hundreds (I do mean hundreds) of products into samba or is it just with the Add Product feature? Thanks. ---
**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\ **Post date:** [May 20, 2018, 1:20pm UTC](https://forum.sambapos.com/t/easy-way-to-enter-product-data-from-access-database-to-sambapos/17497/2 "2018-05-20T13:20:00Z")
You can batch create but it still requires typing it out. There will not be an easy one click option. ---
**Author:** ![QMcKay](https://forum.sambapos.com/user_avatar/forum.sambapos.com/qmckay/32/27925_2.png) [@QMcKay](https://forum.sambapos.com/u/QMcKay)\ **Post date:** [May 20, 2018, 1:48pm UTC](https://forum.sambapos.com/t/easy-way-to-enter-product-data-from-access-database-to-sambapos/17497/3 "2018-05-20T13:48:52Z")
If you save the XLS as CSV, you can read the file using the [API](https://forum.sambapos.com/t/jscript-helpers-and-functions/11966) File helpers in JScript and insert into SambaPOS DB via SQL Helpers. You could also probably use the [API](https://forum.sambapos.com/t/jscript-helpers-and-functions/11966) `host.X` helpers in JScript to attach directly to the Access DB, read it (using SQL statements), and insert that into SambaPOS DB via SQL Helpers. ---
**Author:** ![markjw](https://forum.sambapos.com/user_avatar/forum.sambapos.com/markjw/32/9942_2.png) [@markjw](https://forum.sambapos.com/u/markjw)\ **Post date:** [May 20, 2018, 8:34pm UTC](https://forum.sambapos.com/t/easy-way-to-enter-product-data-from-access-database-to-sambapos/17497/4 "2018-05-20T20:34:22Z")
> [@adam100](#): > > the product data (UPC, Product Name, and Price) are in spreadsheet form Export this into Excel, then follow the guide below to add formulas into Excel to generate the YAML code needed to import using the batch product create feature. > [@Excel file to sambapos](https://forum.sambapos.com/t/excel-file-to-sambapos/9436/19): > > Search the 'net to find tools to convert CSV to YAML. Or use Excel to read the CSV data and use this formula in a Cell: =CONCATENATE("- Name: ", A2, CHAR(10), " GroupCode: ", "Imported", CHAR(10), " Barcode: ", C2, CHAR(10), " Portions: ", CHAR(10), " - Name: Normal", CHAR(10), " Price: ", G2) That produces YAML formatted data from your CSV file. Copy the formula to every row. warning You will probably want to clean up your CSV data file. There are duplicate Products, and some wi… ---
**Author:** ![adam100](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/a/f4b2a3/32.png) [@adam100](https://forum.sambapos.com/u/adam100)\ **Post date:** [August 11, 2018, 5:39pm UTC](https://forum.sambapos.com/t/easy-way-to-enter-product-data-from-access-database-to-sambapos/17497/5 "2018-08-11T17:39:57Z")
Sorry it took me so long to reply, been crazy busy. Thanks so much. You have no idea how much time this saves me. Wonderful! 😃