ODBC guide

Update multiple products from CSV

Updates multiple products from an external source. Use UPDATE Products SOURCE('ODBC', ...) with a connection string and a SELECT whose column names (or aliases) match the product columns to update (e.g. Id, TaxCode). Works with ZappySys CSV Driver, SQL Server, MySQL, PostgreSQL, or any ODBC source.

UPDATE Products
SOURCE('ODBC',

--File input example (use as to match Column name allowed in Products Table to write)
--'Driver={ZappySys CSV Driver};DataPath=c:\data\products.csv',
--'SELECT P_ID AS Id,P_TAXCODE AS TaxCode FROM $'

--Direct input example
'Driver={ZappySys CSV Driver}',
'SELECT ''abcd'' AS Id, ''DC010500'' AS TaxCode UNION
 SELECT ''xyz'' AS Id, ''DC010500'' AS TaxCode UNION
 SELECT ''zzz'' AS Id, ''DC010500'' AS TaxCode 
'
)