I stepped outside to buy a hotdog. When I came back, there was a dialog box
asking if I wanted to save Book1 and another to save Book2. So it did work.
I'm not sure why it won't save as the file I designated in the beginning, but
it did work so I'm happy.
Thanks,Patti
From: Tony IJntema <[email protected]>
To: [email protected]
Sent: Monday, November 14, 2016 10:42 AM
Subject: RE: More Re: [RBASE-L] - Can't export any data
#yiv1316191506 #yiv1316191506 -- _filtered #yiv1316191506 {panose-1:2 4 5 3 5 4
6 3 2 4;} _filtered #yiv1316191506 {font-family:Calibri;panose-1:2 15 5 2 2 2 4
3 2 4;} _filtered #yiv1316191506 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4
2 4;} _filtered #yiv1316191506 {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2
4;} _filtered #yiv1316191506 {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2
4;} _filtered #yiv1316191506 {font-family:HelveticaNeue;panose-1:0 0 0 0 0 0 0
0 0 0;}#yiv1316191506 #yiv1316191506 p.yiv1316191506MsoNormal, #yiv1316191506
li.yiv1316191506MsoNormal, #yiv1316191506 div.yiv1316191506MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv1316191506 a:link,
#yiv1316191506 span.yiv1316191506MsoHyperlink
{color:blue;text-decoration:underline;}#yiv1316191506 a:visited, #yiv1316191506
span.yiv1316191506MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv1316191506 p
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506MsoAcetate, #yiv1316191506 li.yiv1316191506MsoAcetate,
#yiv1316191506 div.yiv1316191506MsoAcetate
{margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;}#yiv1316191506
p.yiv1316191506msoacetate, #yiv1316191506 li.yiv1316191506msoacetate,
#yiv1316191506 div.yiv1316191506msoacetate
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal0, #yiv1316191506 li.yiv1316191506msonormal0,
#yiv1316191506 div.yiv1316191506msonormal0
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal, #yiv1316191506 li.yiv1316191506msonormal,
#yiv1316191506 div.yiv1316191506msonormal
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msochpdefault, #yiv1316191506 li.yiv1316191506msochpdefault,
#yiv1316191506 div.yiv1316191506msochpdefault
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal1, #yiv1316191506 li.yiv1316191506msonormal1,
#yiv1316191506 div.yiv1316191506msonormal1
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msochpdefault1, #yiv1316191506 li.yiv1316191506msochpdefault1,
#yiv1316191506 div.yiv1316191506msochpdefault1
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal2, #yiv1316191506 li.yiv1316191506msonormal2,
#yiv1316191506 div.yiv1316191506msonormal2
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal01, #yiv1316191506 li.yiv1316191506msonormal01,
#yiv1316191506 div.yiv1316191506msonormal01
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal3, #yiv1316191506 li.yiv1316191506msonormal3,
#yiv1316191506 div.yiv1316191506msonormal3
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msochpdefault2, #yiv1316191506 li.yiv1316191506msochpdefault2,
#yiv1316191506 div.yiv1316191506msochpdefault2
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal11, #yiv1316191506 li.yiv1316191506msonormal11,
#yiv1316191506 div.yiv1316191506msonormal11
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msochpdefault11, #yiv1316191506 li.yiv1316191506msochpdefault11,
#yiv1316191506 div.yiv1316191506msochpdefault11
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal4, #yiv1316191506 li.yiv1316191506msonormal4,
#yiv1316191506 div.yiv1316191506msonormal4
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msoacetate1, #yiv1316191506 li.yiv1316191506msoacetate1,
#yiv1316191506 div.yiv1316191506msoacetate1
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal02, #yiv1316191506 li.yiv1316191506msonormal02,
#yiv1316191506 div.yiv1316191506msonormal02
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal5, #yiv1316191506 li.yiv1316191506msonormal5,
#yiv1316191506 div.yiv1316191506msonormal5
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msochpdefault3, #yiv1316191506 li.yiv1316191506msochpdefault3,
#yiv1316191506 div.yiv1316191506msochpdefault3
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal12, #yiv1316191506 li.yiv1316191506msonormal12,
#yiv1316191506 div.yiv1316191506msonormal12
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msochpdefault12, #yiv1316191506 li.yiv1316191506msochpdefault12,
#yiv1316191506 div.yiv1316191506msochpdefault12
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal21, #yiv1316191506 li.yiv1316191506msonormal21,
#yiv1316191506 div.yiv1316191506msonormal21
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal011, #yiv1316191506 li.yiv1316191506msonormal011,
#yiv1316191506 div.yiv1316191506msonormal011
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal31, #yiv1316191506 li.yiv1316191506msonormal31,
#yiv1316191506 div.yiv1316191506msonormal31
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msochpdefault21, #yiv1316191506 li.yiv1316191506msochpdefault21,
#yiv1316191506 div.yiv1316191506msochpdefault21
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal111, #yiv1316191506 li.yiv1316191506msonormal111,
#yiv1316191506 div.yiv1316191506msonormal111
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msochpdefault111, #yiv1316191506
li.yiv1316191506msochpdefault111, #yiv1316191506
div.yiv1316191506msochpdefault111
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
span.yiv1316191506msohyperlink {}#yiv1316191506
span.yiv1316191506msohyperlinkfollowed {}#yiv1316191506
span.yiv1316191506msohyperlink1 {}#yiv1316191506
span.yiv1316191506msohyperlinkfollowed1 {}#yiv1316191506
span.yiv1316191506msohyperlink21 {}#yiv1316191506
span.yiv1316191506msohyperlinkfollowed21 {}#yiv1316191506
span.yiv1316191506msohyperlink111 {}#yiv1316191506
span.yiv1316191506msohyperlinkfollowed111 {}#yiv1316191506
span.yiv1316191506emailstyle18111 {}#yiv1316191506
span.yiv1316191506emailstyle2911 {}#yiv1316191506
span.yiv1316191506emailstyle3011 {}#yiv1316191506
span.yiv1316191506emailstyle451 {}#yiv1316191506
span.yiv1316191506emailstyle461 {}#yiv1316191506 span.yiv1316191506emailstyle69
{}#yiv1316191506 p.yiv1316191506msonormal6, #yiv1316191506
li.yiv1316191506msonormal6, #yiv1316191506 div.yiv1316191506msonormal6
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv1316191506
span.yiv1316191506msohyperlink2
{color:blue;text-decoration:underline;}#yiv1316191506
span.yiv1316191506msohyperlinkfollowed2
{color:purple;text-decoration:underline;}#yiv1316191506
p.yiv1316191506msoacetate2, #yiv1316191506 li.yiv1316191506msoacetate2,
#yiv1316191506 div.yiv1316191506msoacetate2
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal03, #yiv1316191506 li.yiv1316191506msonormal03,
#yiv1316191506 div.yiv1316191506msonormal03
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal7, #yiv1316191506 li.yiv1316191506msonormal7,
#yiv1316191506 div.yiv1316191506msonormal7
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msochpdefault4, #yiv1316191506 li.yiv1316191506msochpdefault4,
#yiv1316191506 div.yiv1316191506msochpdefault4
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal13, #yiv1316191506 li.yiv1316191506msonormal13,
#yiv1316191506 div.yiv1316191506msonormal13
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msochpdefault13, #yiv1316191506 li.yiv1316191506msochpdefault13,
#yiv1316191506 div.yiv1316191506msochpdefault13
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal22, #yiv1316191506 li.yiv1316191506msonormal22,
#yiv1316191506 div.yiv1316191506msonormal22
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal012, #yiv1316191506 li.yiv1316191506msonormal012,
#yiv1316191506 div.yiv1316191506msonormal012
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal32, #yiv1316191506 li.yiv1316191506msonormal32,
#yiv1316191506 div.yiv1316191506msonormal32
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msochpdefault22, #yiv1316191506 li.yiv1316191506msochpdefault22,
#yiv1316191506 div.yiv1316191506msochpdefault22
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal112, #yiv1316191506 li.yiv1316191506msonormal112,
#yiv1316191506 div.yiv1316191506msonormal112
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msochpdefault112, #yiv1316191506
li.yiv1316191506msochpdefault112, #yiv1316191506
div.yiv1316191506msochpdefault112
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal41, #yiv1316191506 li.yiv1316191506msonormal41,
#yiv1316191506 div.yiv1316191506msonormal41
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv1316191506
span.yiv1316191506msohyperlink11
{color:blue;text-decoration:underline;}#yiv1316191506
span.yiv1316191506msohyperlinkfollowed11
{color:purple;text-decoration:underline;}#yiv1316191506
p.yiv1316191506msoacetate11, #yiv1316191506 li.yiv1316191506msoacetate11,
#yiv1316191506 div.yiv1316191506msoacetate11
{margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;}#yiv1316191506
p.yiv1316191506msonormal021, #yiv1316191506 li.yiv1316191506msonormal021,
#yiv1316191506 div.yiv1316191506msonormal021
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal51, #yiv1316191506 li.yiv1316191506msonormal51,
#yiv1316191506 div.yiv1316191506msonormal51
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msochpdefault31, #yiv1316191506 li.yiv1316191506msochpdefault31,
#yiv1316191506 div.yiv1316191506msochpdefault31
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal121, #yiv1316191506 li.yiv1316191506msonormal121,
#yiv1316191506 div.yiv1316191506msonormal121
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msochpdefault121, #yiv1316191506
li.yiv1316191506msochpdefault121, #yiv1316191506
div.yiv1316191506msochpdefault121
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal211, #yiv1316191506 li.yiv1316191506msonormal211,
#yiv1316191506 div.yiv1316191506msonormal211
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal0111, #yiv1316191506 li.yiv1316191506msonormal0111,
#yiv1316191506 div.yiv1316191506msonormal0111
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal311, #yiv1316191506 li.yiv1316191506msonormal311,
#yiv1316191506 div.yiv1316191506msonormal311
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msochpdefault211, #yiv1316191506
li.yiv1316191506msochpdefault211, #yiv1316191506
div.yiv1316191506msochpdefault211
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msonormal1111, #yiv1316191506 li.yiv1316191506msonormal1111,
#yiv1316191506 div.yiv1316191506msonormal1111
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv1316191506
p.yiv1316191506msochpdefault1111, #yiv1316191506
li.yiv1316191506msochpdefault1111, #yiv1316191506
div.yiv1316191506msochpdefault1111
{margin-right:0cm;margin-left:0cm;font-size:10.0pt;}#yiv1316191506
span.yiv1316191506msohyperlink211
{color:blue;text-decoration:underline;}#yiv1316191506
span.yiv1316191506msohyperlinkfollowed211
{color:purple;text-decoration:underline;}#yiv1316191506
span.yiv1316191506msohyperlink1111
{color:blue;text-decoration:underline;}#yiv1316191506
span.yiv1316191506msohyperlinkfollowed1111
{color:purple;text-decoration:underline;}#yiv1316191506
span.yiv1316191506emailstyle181111 {color:#1F497D;}#yiv1316191506
span.yiv1316191506emailstyle29111 {color:windowtext;}#yiv1316191506
span.yiv1316191506emailstyle30111 {color:windowtext;}#yiv1316191506
span.yiv1316191506emailstyle4511 {color:#1F497D;}#yiv1316191506
span.yiv1316191506emailstyle4611
{color:#1F497D;font-weight:normal;font-style:normal;}#yiv1316191506
span.yiv1316191506emailstyle691
{color:#1F497D;font-weight:normal;font-style:normal;}#yiv1316191506
span.yiv1316191506BalloonTextChar {}#yiv1316191506
span.yiv1316191506EmailStyle99
{color:#1F497D;font-weight:normal;font-style:normal;}#yiv1316191506
.yiv1316191506MsoChpDefault {font-size:10.0pt;} _filtered #yiv1316191506
{margin:72.0pt 72.0pt 72.0pt 72.0pt;}#yiv1316191506
div.yiv1316191506WordSection1 {}#yiv1316191506 Maybe a workaround, but it
worksA couple of week ago I had a big spreadsheet too, which did not
work.Export the file as a CSV and open it with Excel Tony From: 'Patti
Jakusz' via RBASE-L [mailto:[email protected]]
Sent: maandag 14 november 2016 16:30
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 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.
--
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.
