Author Topic: Connection MS Excel to SambaPOS database  (Read 2972 times)

lewasabisushi

  • Newbie
  • *
  • Posts: 25
Connection MS Excel to SambaPOS database
« on: February 18, 2013, 03:59:40 am »
Hi all
I want to use MS Excel to retrieve data from sambapos instead of using csv from reports. I just don't know which table should I connect to. I tried almost all table but I could not find the transaction data (even from transaction table).
Any suggestion?
Thank you.

NB: I want to know which data should I retrieve if I want:
waitress performance, most wanted items, gifted items, ticket tag, item's value, and some others

One33Seven

  • Newbie
  • *
  • Posts: 12
Re: Connection MS Excel to SambaPOS database
« Reply #1 on: February 18, 2013, 04:49:42 am »
You can do it by adding a data connection to your excel sheet and then adding a macro script to retrieve and format the data.

lewasabisushi

  • Newbie
  • *
  • Posts: 25
Re: Connection MS Excel to SambaPOS database
« Reply #2 on: February 18, 2013, 03:27:54 pm »
Yes I already done that but I cannot find which table holds transaction history. I have blank table when I connect Excel with Transaction table.

lemmings

  • Full Member
  • ***
  • Posts: 165
Re: Connection MS Excel to SambaPOS database
« Reply #3 on: February 18, 2013, 04:10:50 pm »
Transaction table is for inventory and recipe (tracking stock use)

You need to look at tables Tickets, TicketItems and TicketProperties

These will show you the sales data, the menu items and any modifiers you may have set up

lewasabisushi

  • Newbie
  • *
  • Posts: 25
Re: Connection MS Excel to SambaPOS database
« Reply #4 on: February 19, 2013, 11:13:45 am »
Yes, It was Ticket Properties.
Thank You.

Buscad0r

  • Newbie
  • *
  • Posts: 12
Need Help Connection MS Excel to SambaPOS database
« Reply #5 on: February 04, 2014, 11:28:27 am »
Hi, I found your lines looking for ways to use Ms Excel to query the database, can you please help me with some example of how to do it? maybe a step by step procedure? which db connector should I use?  which is the macro scrip?

best regards