We work with a 2 digit year here. The nature of our data does not lend itself
to getting confused about the century, so we'd rather cut down on the extra
keystrokes.
In the last version of Excel, I had to worry about date formats all the time,
but, I noticed last Wed that our new Excel knows what century it is. Yea!
Patti
From: Gary Wendike <[email protected]>
To: [email protected]
Sent: Monday, November 14, 2016 11:04 AM
Subject: Re: More Re: [RBASE-L] - Can't export any data
Patti, two things I noticed and both deal with date. first, what is your date
format set to, your code indicates mm/dd/yy. Normal is mm/dd/yyyy. Second,
you do not need single quotes around the date.
Gary
Sent from my Verizon Wireless 4G LTE smartphone
-------- Original message --------
From: 'Patti Jakusz' via RBASE-L <[email protected]>
Date: 11/14/2016 9:29 AM (GMT-06:00)
To: [email protected]
Subject: Re: More Re: [RBASE-L] - Can't export any data
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
#yiv0510108190 -- filtered {panose-1:2 4 5 3 5 4 6 3 2 4;}#yiv0510108190
filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv0510108190
filtered {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv0510108190
filtered {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv0510108190
filtered {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;}#yiv0510108190
filtered {font-family:HelveticaNeue;panose-1:0 0 0 0 0 0 0 0 0
0;}#yiv0510108190 p.yiv0510108190MsoNormal, #yiv0510108190
li.yiv0510108190MsoNormal, #yiv0510108190 div.yiv0510108190MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv0510108190 a:link,
#yiv0510108190 span.yiv0510108190MsoHyperlink
{color:blue;text-decoration:underline;}#yiv0510108190 a:visited, #yiv0510108190
span.yiv0510108190MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv0510108190 p
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv0510108190
p.yiv0510108190MsoAcetate, #yiv0510108190 li.yiv0510108190MsoAcetate,
#yiv0510108190 div.yiv0510108190MsoAcetate
{margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;}#yiv0510108190
p.yiv0510108190msoacetate, #yiv0510108190 li.yiv0510108190msoacetate,
#yiv0510108190 div.yiv0510108190msoacetate
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv0510108190
p.yiv0510108190msonormal0, #yiv0510108190 li.yiv0510108190msonormal0,
#yiv0510108190 div.yiv0510108190msonormal0
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv0510108190
p.yiv0510108190msonormal, #yiv0510108190 li.yiv0510108190msonormal,
#yiv0510108190 div.yiv0510108190msonormal
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv0510108190
p.yiv0510108190msochpdefault, #yiv0510108190 li.yiv0510108190msochpdefault,
#yiv0510108190 div.yiv0510108190msochpdefault
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv0510108190
p.yiv0510108190msonormal1, #yiv0510108190 li.yiv0510108190msonormal1,
#yiv0510108190 div.yiv0510108190msonormal1
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv0510108190
p.yiv0510108190msochpdefault1, #yiv0510108190 li.yiv0510108190msochpdefault1,
#yiv0510108190 div.yiv0510108190msochpdefault1
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv0510108190
p.yiv0510108190msonormal2, #yiv0510108190 li.yiv0510108190msonormal2,
#yiv0510108190 div.yiv0510108190msonormal2
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv0510108190
p.yiv0510108190msonormal01, #yiv0510108190 li.yiv0510108190msonormal01,
#yiv0510108190 div.yiv0510108190msonormal01
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv0510108190
p.yiv0510108190msonormal3, #yiv0510108190 li.yiv0510108190msonormal3,
#yiv0510108190 div.yiv0510108190msonormal3
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv0510108190
p.yiv0510108190msochpdefault2, #yiv0510108190 li.yiv0510108190msochpdefault2,
#yiv0510108190 div.yiv0510108190msochpdefault2
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv0510108190
p.yiv0510108190msonormal11, #yiv0510108190 li.yiv0510108190msonormal11,
#yiv0510108190 div.yiv0510108190msonormal11
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv0510108190
p.yiv0510108190msochpdefault11, #yiv0510108190 li.yiv0510108190msochpdefault11,
#yiv0510108190 div.yiv0510108190msochpdefault11
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv0510108190
span.yiv0510108190msohyperlink {}#yiv0510108190
span.yiv0510108190msohyperlinkfollowed {}#yiv0510108190
span.yiv0510108190balloontextchar {}#yiv0510108190
span.yiv0510108190msohyperlink2 {}#yiv0510108190
span.yiv0510108190msohyperlinkfollowed2 {}#yiv0510108190
span.yiv0510108190msohyperlink11 {}#yiv0510108190
span.yiv0510108190msohyperlinkfollowed11 {}#yiv0510108190
span.yiv0510108190emailstyle1811 {}#yiv0510108190
span.yiv0510108190emailstyle291 {}#yiv0510108190
span.yiv0510108190emailstyle301 {}#yiv0510108190 span.yiv0510108190emailstyle45
{}#yiv0510108190 span.yiv0510108190emailstyle46 {}#yiv0510108190
p.yiv0510108190msonormal4, #yiv0510108190 li.yiv0510108190msonormal4,
#yiv0510108190 div.yiv0510108190msonormal4
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv0510108190
span.yiv0510108190msohyperlink1
{color:blue;text-decoration:underline;}#yiv0510108190
span.yiv0510108190msohyperlinkfollowed1
{color:purple;text-decoration:underline;}#yiv0510108190
p.yiv0510108190msoacetate1, #yiv0510108190 li.yiv0510108190msoacetate1,
#yiv0510108190 div.yiv0510108190msoacetate1
{margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;}#yiv0510108190
span.yiv0510108190balloontextchar1 {}#yiv0510108190 p.yiv0510108190msonormal02,
#yiv0510108190 li.yiv0510108190msonormal02, #yiv0510108190
div.yiv0510108190msonormal02
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv0510108190
p.yiv0510108190msonormal5, #yiv0510108190 li.yiv0510108190msonormal5,
#yiv0510108190 div.yiv0510108190msonormal5
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv0510108190
p.yiv0510108190msochpdefault3, #yiv0510108190 li.yiv0510108190msochpdefault3,
#yiv0510108190 div.yiv0510108190msochpdefault3
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv0510108190
p.yiv0510108190msonormal12, #yiv0510108190 li.yiv0510108190msonormal12,
#yiv0510108190 div.yiv0510108190msonormal12
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv0510108190
p.yiv0510108190msochpdefault12, #yiv0510108190 li.yiv0510108190msochpdefault12,
#yiv0510108190 div.yiv0510108190msochpdefault12
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv0510108190
p.yiv0510108190msonormal21, #yiv0510108190 li.yiv0510108190msonormal21,
#yiv0510108190 div.yiv0510108190msonormal21
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv0510108190
p.yiv0510108190msonormal011, #yiv0510108190 li.yiv0510108190msonormal011,
#yiv0510108190 div.yiv0510108190msonormal011
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv0510108190
p.yiv0510108190msonormal31, #yiv0510108190 li.yiv0510108190msonormal31,
#yiv0510108190 div.yiv0510108190msonormal31
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv0510108190
p.yiv0510108190msochpdefault21, #yiv0510108190 li.yiv0510108190msochpdefault21,
#yiv0510108190 div.yiv0510108190msochpdefault21
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv0510108190
p.yiv0510108190msonormal111, #yiv0510108190 li.yiv0510108190msonormal111,
#yiv0510108190 div.yiv0510108190msonormal111
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv0510108190
p.yiv0510108190msochpdefault111, #yiv0510108190
li.yiv0510108190msochpdefault111, #yiv0510108190
div.yiv0510108190msochpdefault111
{margin-right:0cm;margin-left:0cm;font-size:10.0pt;}#yiv0510108190
span.yiv0510108190msohyperlink21
{color:blue;text-decoration:underline;}#yiv0510108190
span.yiv0510108190msohyperlinkfollowed21
{color:purple;text-decoration:underline;}#yiv0510108190
span.yiv0510108190msohyperlink111
{color:blue;text-decoration:underline;}#yiv0510108190
span.yiv0510108190msohyperlinkfollowed111
{color:purple;text-decoration:underline;}#yiv0510108190
span.yiv0510108190emailstyle18111 {color:#1F497D;}#yiv0510108190
span.yiv0510108190emailstyle2911 {color:windowtext;}#yiv0510108190
span.yiv0510108190emailstyle3011 {color:windowtext;}#yiv0510108190
span.yiv0510108190emailstyle451 {color:#1F497D;}#yiv0510108190
span.yiv0510108190emailstyle461
{color:#1F497D;font-weight:normal;font-style:normal;}#yiv0510108190
span.yiv0510108190BalloonTextChar {}#yiv0510108190
span.yiv0510108190EmailStyle69
{color:#1F497D;font-weight:normal;font-style:normal;}#yiv0510108190
.yiv0510108190MsoChpDefault {font-size:10.0pt;}#yiv0510108190 filtered
{margin:72.0pt 72.0pt 72.0pt 72.0pt;}#yiv0510108190
div.yiv0510108190WordSection1 {}#yiv0510108190 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.
--
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.
