Oh. It's in help under Export but not under Gateway. I had been looking at
Gateway help.
But I tried it twice and no file was generated.
GATEWAY EXPORT XLSW pjtry35.xlsx SELECT * FROM ParticipantID WHERE
IDO02DAT>'05/01/16' OPTION COL_NAMES ON
Thank you, though.Patti
From: Tony IJntema <[email protected]>
To: [email protected]
Sent: Monday, November 14, 2016 9:39 AM
Subject: RE: More Re: [RBASE-L] - Can't export any data
#yiv9756482919 #yiv9756482919 -- _filtered #yiv9756482919 {panose-1:2 4 5 3 5 4
6 3 2 4;} _filtered #yiv9756482919 {font-family:Calibri;panose-1:2 15 5 2 2 2 4
3 2 4;} _filtered #yiv9756482919 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4
2 4;} _filtered #yiv9756482919 {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2
4;} _filtered #yiv9756482919 {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2
4;} _filtered #yiv9756482919 {font-family:HelveticaNeue;panose-1:0 0 0 0 0 0 0
0 0 0;}#yiv9756482919 #yiv9756482919 p.yiv9756482919MsoNormal, #yiv9756482919
li.yiv9756482919MsoNormal, #yiv9756482919 div.yiv9756482919MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv9756482919 a:link,
#yiv9756482919 span.yiv9756482919MsoHyperlink
{color:blue;text-decoration:underline;}#yiv9756482919 a:visited, #yiv9756482919
span.yiv9756482919MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv9756482919 p
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv9756482919
p.yiv9756482919MsoAcetate, #yiv9756482919 li.yiv9756482919MsoAcetate,
#yiv9756482919 div.yiv9756482919MsoAcetate
{margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;}#yiv9756482919
p.yiv9756482919msoacetate, #yiv9756482919 li.yiv9756482919msoacetate,
#yiv9756482919 div.yiv9756482919msoacetate
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv9756482919
p.yiv9756482919msonormal0, #yiv9756482919 li.yiv9756482919msonormal0,
#yiv9756482919 div.yiv9756482919msonormal0
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv9756482919
p.yiv9756482919msonormal, #yiv9756482919 li.yiv9756482919msonormal,
#yiv9756482919 div.yiv9756482919msonormal
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv9756482919
p.yiv9756482919msochpdefault, #yiv9756482919 li.yiv9756482919msochpdefault,
#yiv9756482919 div.yiv9756482919msochpdefault
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv9756482919
p.yiv9756482919msonormal1, #yiv9756482919 li.yiv9756482919msonormal1,
#yiv9756482919 div.yiv9756482919msonormal1
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv9756482919
p.yiv9756482919msochpdefault1, #yiv9756482919 li.yiv9756482919msochpdefault1,
#yiv9756482919 div.yiv9756482919msochpdefault1
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv9756482919
p.yiv9756482919msonormal2, #yiv9756482919 li.yiv9756482919msonormal2,
#yiv9756482919 div.yiv9756482919msonormal2
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv9756482919
p.yiv9756482919msonormal01, #yiv9756482919 li.yiv9756482919msonormal01,
#yiv9756482919 div.yiv9756482919msonormal01
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv9756482919
p.yiv9756482919msonormal3, #yiv9756482919 li.yiv9756482919msonormal3,
#yiv9756482919 div.yiv9756482919msonormal3
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv9756482919
p.yiv9756482919msochpdefault2, #yiv9756482919 li.yiv9756482919msochpdefault2,
#yiv9756482919 div.yiv9756482919msochpdefault2
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv9756482919
p.yiv9756482919msonormal11, #yiv9756482919 li.yiv9756482919msonormal11,
#yiv9756482919 div.yiv9756482919msonormal11
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv9756482919
p.yiv9756482919msochpdefault11, #yiv9756482919 li.yiv9756482919msochpdefault11,
#yiv9756482919 div.yiv9756482919msochpdefault11
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv9756482919
span.yiv9756482919msohyperlink {}#yiv9756482919
span.yiv9756482919msohyperlinkfollowed {}#yiv9756482919
span.yiv9756482919balloontextchar {}#yiv9756482919
span.yiv9756482919msohyperlink2 {}#yiv9756482919
span.yiv9756482919msohyperlinkfollowed2 {}#yiv9756482919
span.yiv9756482919msohyperlink11 {}#yiv9756482919
span.yiv9756482919msohyperlinkfollowed11 {}#yiv9756482919
span.yiv9756482919emailstyle1811 {}#yiv9756482919
span.yiv9756482919emailstyle291 {}#yiv9756482919
span.yiv9756482919emailstyle301 {}#yiv9756482919 span.yiv9756482919emailstyle45
{}#yiv9756482919 span.yiv9756482919emailstyle46 {}#yiv9756482919
p.yiv9756482919msonormal4, #yiv9756482919 li.yiv9756482919msonormal4,
#yiv9756482919 div.yiv9756482919msonormal4
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv9756482919
span.yiv9756482919msohyperlink1
{color:blue;text-decoration:underline;}#yiv9756482919
span.yiv9756482919msohyperlinkfollowed1
{color:purple;text-decoration:underline;}#yiv9756482919
p.yiv9756482919msoacetate1, #yiv9756482919 li.yiv9756482919msoacetate1,
#yiv9756482919 div.yiv9756482919msoacetate1
{margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;}#yiv9756482919
span.yiv9756482919balloontextchar1 {}#yiv9756482919 p.yiv9756482919msonormal02,
#yiv9756482919 li.yiv9756482919msonormal02, #yiv9756482919
div.yiv9756482919msonormal02
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv9756482919
p.yiv9756482919msonormal5, #yiv9756482919 li.yiv9756482919msonormal5,
#yiv9756482919 div.yiv9756482919msonormal5
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv9756482919
p.yiv9756482919msochpdefault3, #yiv9756482919 li.yiv9756482919msochpdefault3,
#yiv9756482919 div.yiv9756482919msochpdefault3
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv9756482919
p.yiv9756482919msonormal12, #yiv9756482919 li.yiv9756482919msonormal12,
#yiv9756482919 div.yiv9756482919msonormal12
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv9756482919
p.yiv9756482919msochpdefault12, #yiv9756482919 li.yiv9756482919msochpdefault12,
#yiv9756482919 div.yiv9756482919msochpdefault12
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv9756482919
p.yiv9756482919msonormal21, #yiv9756482919 li.yiv9756482919msonormal21,
#yiv9756482919 div.yiv9756482919msonormal21
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv9756482919
p.yiv9756482919msonormal011, #yiv9756482919 li.yiv9756482919msonormal011,
#yiv9756482919 div.yiv9756482919msonormal011
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv9756482919
p.yiv9756482919msonormal31, #yiv9756482919 li.yiv9756482919msonormal31,
#yiv9756482919 div.yiv9756482919msonormal31
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv9756482919
p.yiv9756482919msochpdefault21, #yiv9756482919 li.yiv9756482919msochpdefault21,
#yiv9756482919 div.yiv9756482919msochpdefault21
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv9756482919
p.yiv9756482919msonormal111, #yiv9756482919 li.yiv9756482919msonormal111,
#yiv9756482919 div.yiv9756482919msonormal111
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv9756482919
p.yiv9756482919msochpdefault111, #yiv9756482919
li.yiv9756482919msochpdefault111, #yiv9756482919
div.yiv9756482919msochpdefault111
{margin-right:0cm;margin-left:0cm;font-size:10.0pt;}#yiv9756482919
span.yiv9756482919msohyperlink21
{color:blue;text-decoration:underline;}#yiv9756482919
span.yiv9756482919msohyperlinkfollowed21
{color:purple;text-decoration:underline;}#yiv9756482919
span.yiv9756482919msohyperlink111
{color:blue;text-decoration:underline;}#yiv9756482919
span.yiv9756482919msohyperlinkfollowed111
{color:purple;text-decoration:underline;}#yiv9756482919
span.yiv9756482919emailstyle18111 {color:#1F497D;}#yiv9756482919
span.yiv9756482919emailstyle2911 {color:windowtext;}#yiv9756482919
span.yiv9756482919emailstyle3011 {color:windowtext;}#yiv9756482919
span.yiv9756482919emailstyle451 {color:#1F497D;}#yiv9756482919
span.yiv9756482919emailstyle461
{color:#1F497D;font-weight:normal;font-style:normal;}#yiv9756482919
span.yiv9756482919BalloonTextChar {}#yiv9756482919
span.yiv9756482919EmailStyle69
{color:#1F497D;font-weight:normal;font-style:normal;}#yiv9756482919
.yiv9756482919MsoChpDefault {font-size:10.0pt;} _filtered #yiv9756482919
{margin:72.0pt 72.0pt 72.0pt 72.0pt;}#yiv9756482919
div.yiv9756482919WordSection1 {}#yiv9756482919 Have a look at the Help gateway
exportFor a Workbook it should be: XLSWTony From: 'Patti Jakusz' via
RBASE-L [mailto:[email protected]]
Sent: maandag 14 november 2016 15:19
To: [email protected]
Subject: Re: More Re: [RBASE-L] - Can't export any data I just tried it now
and it didn't give me the correct version of Excel. My table has 433 columns.
If I export using the wizard, I can export it as a workbook in our newest
version of Excel with all the new columns it allows. I tried your statement
with .xlsx extension and it wouldn't open. Said it was the wrong extension.
Thank you, though. Patti From: Stephen Markson <[email protected]>
To: "[email protected]" <[email protected]>
Sent: Thursday, November 10, 2016 1:36 PM
Subject: RE: More Re: [RBASE-L] - Can't export any data Did you try this,
Patti? GATEWAY EXPORT XLS pjtry30.xls SELECT… FROM ParticipantID WHERE (your
where clause) OPTION COL_NAMES ON In the SELECT clause you can use alternate
column names, e.g.… ,IDO02DAT AS `IDO 2 Date`, … Regards, Stephen MarksonThe
Pharmacy Examining Board of Canada416.979.2431 x251 From: 'Patti Jakusz' via
RBASE-L [mailto:[email protected]]
Sent: Tuesday, November 08, 2016 1:20 PM
To: [email protected]
Subject: [RBASE-L] - Can't export any data Hello, I'm still using RBase 9.5
extreme. We have Microsoft Office 2013 on the office PC I get this error
message when I try to export to Excel using gateway. Error of Data Export:
Access Violation at Address 00405E34 in module 'RGB95_32.exe' Read of address
FFFFFFF7 I sometimes get a 4KB file created, and if I click on it I get a
messages that says "Do you want to save changes to Book1?" But no data shows
up. This morning, when I tried, it would go through all 4000 records and then
give me the error. Now I get the error immediately. When I try to export to a
CSV file, I get the hourglass spinner thing for a while and then it stops.
When I open the file it created, all I see are column headings. So I tried my
laptop. I first exported into a CSV file and it was working - but I realized I
forgot to change my date settings. So I cancelled the operation and started
again. Now it won't work. I get the same results as when I tried it on the
office PC - an hourglass then nothing but a file with column headings. I
tried exporting to Excel on the laptop and I get the exact same error message
as I did on the office pc. So I tried someone else's computer at work and it
still wouldn't export. I replaced the database with a copy I had on a
flashdrive and it didn't work. I have to get these files exported. I'm running
out of ideas. The table has too many columns to use anything other formats.
Can anyone figure out what is wrong? Thanks,Patti --
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 [email protected].
For more options, visit https://groups.google.com/d/optout. --
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 [email protected].
For more options, visit https://groups.google.com/d/optout.--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
