Download Data from Table

V5 Question
1

What’s the best way to export data from one of the tables in the database? I’m assuming MS SQL Server Management Studio and run a Select query?

2

Depends, if you are looking to export it from SSMS you can, if you want to allow user to export it themselves, probably Data Export from SambaPOS is the way to go

SSMS

SELECT * FROM dbo.[TableName]

SambaPOS

{REPORT SQL DETAILS:

SELECT * FROM dbo.[TableName]

:F.ColumnNameA, F.ColumnNameB, F.ColumnNameC
::"{0}", "{1}", "{2}"}
3

Awesome cheers, I’ll try that.

4

Sorted, thanks for the assistance. :+1: