Dan
Try changing
GATEWAY EXPORT XLS Customers_123.xls
to
GATEWAY EXPORT XLSW Customers_123.xlsx
If you want a small file you could trying exporting to CSV then have Excel
open the csv file.
Buddy
From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of Dan
Goldberg
Sent: Thursday, April 5, 2018 5:20 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - gateway export to xlsx
I am using a command line export to xls like the sample.
GATEWAY EXPORT XLS Customers_123.xls +
SELECT +
Company AS `Company Name`, +
CustID AS `Customer ID`, +
CustAddress AS `Company Address`, +
(CustCity+','&CustState&CustZip) AS `City, State, and Zip Code` +
FROM Customer ORDER by Company +
OPTION COL_NAMES ON +
|TAB_NAME Customer List
Is there a way to export to xlsx? The reason being is xlsx is a smaller file
size.
TIA
Dan Goldberg
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com
<mailto:rbase-l+unsubscr...@googlegroups.com> .
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
