Thanks  Roy

Code used to export
          sSQL := 'CREATE STORE "%s" AS LOCAL PATH %s';
          sSQL := Format(sSQL,[ExportedItems,Quotedstr(sDirectory)]);
          RunSQL(sSQL);
          {********************************************************************}
          sSQL := 'CREATE TEMPORARY TABLE "ExportedItems" AS';
          sSQL := sSQL + ' SELECT * FROM %s.Items   WITH DATA';
          RunDDL(sSQL);
          {********************************************************************}
          sFileName := 'TB_Items' + sFileStamp;
           sSQL := 'EXPORT TABLE RAM.ExportedItems TO "%s.saw6" IN STORE "ExportedData"';
           sSQL := Format(sSQL,[sFileName]);
           RunSQL(sSQL);
          {********************************************************************}

txt file after export.
1,10,1,552,1,"A2","A2","Item Name A2"
1,10,1,552,39,"A2","A2","Item Name A2"
1,10,1,551,39,"A1","A1","Item Name A1"
1,10,1,551,1,"A1","A1","Item Name A1"


table data exported from  with the blow order
CREATE TABLE "Items"
(
"BranchSysNo" INTEGER,
"YearSysNo" INTEGER DEFAULT -1,
"StoreSysNo" INTEGER,
"ItemSysNo" INTEGER,
"UnitSysNo" INTEGER,
"UnitBarcodeNo" VARCHAR(20) COLLATE "ANSI_CI",
"ItemNo" VARCHAR(20) COLLATE "ANSI_CI",
"ItemName_A" VARCHAR(45) COLLATE "ANSI"
)
VERSION 1.00
READWRITE
ENCRYPTED
INDEX PAGE SIZE 4096
BLOB BLOCK SIZE 512
PUBLISH BLOCK SIZE 512
PUBLISH COMPRESSION 0
MAX ROW BUFFER SIZE 65536
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768
MAX PUBLISH BUFFER SIZE 32768!

INSERT INTO "Items" VALUES (1,
                  10,
                  1,
                  551,
                  1,
                  'A1',
                  'A1',
                  'Item Name A1')!

INSERT INTO "Items" VALUES (1,
                  10,
                  1,
                  551,
                  39,
                  'A1',
                  'A1',
                  'Item Name A1')!

INSERT INTO "Items" VALUES (1,
                  10,
                  1,
                  552,
                  39,
                  'A2',
                  'A2',
                  'Item Name A2')!

INSERT INTO "Items" VALUES (1,
                  10,
                  1,
                  552,
                  1,
                  'A2',
                  'A2',
                  'Item Name A2')!
  