Yes, it did work. It just couldn't name the file itself. It called it
Book1.xlsx and Book2.xlsx.
I misnamed it in my first attempt too, but it recognized both as .xlsx. My two
tries were:GATEWAY EXPORT XLSW pjtry35.xls SELECT * FROM ParticipantID WHERE
IDO02DAT>'05/01/16' OPTION COL_NAMES ON
GATEWAY EXPORT XLSW pjtry36.xlsx SELECT * FROM ParticipantID WHERE
IDO02DAT>'05/01/16' OPTION COL_NAMES ON
Patti
From: karentellef via RBASE-L <[email protected]>
To: [email protected]
Sent: Monday, November 14, 2016 11:03 AM
Subject: Re: More Re: [RBASE-L] - Can't export any data
So... the GATEWAY XLSW worked with your .xlsx extension? It just wanted you to
verify a save? I haven't had to export any massive tables yet, so I'm
interested in hearing the solution.
Karen
-----Original Message-----
From: 'Patti Jakusz' via RBASE-L <[email protected]>
To: rbase-l <[email protected]>
Sent: Mon, Nov 14, 2016 9:48 am
Subject: Re: More Re: [RBASE-L] - Can't export any data
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
#yiv4013832528 #yiv4013832528AOLMsgPart_2_11c6db24-d47c-4da6-9aaf-0d83aa9a61fb
td{color:black;}#yiv4013832528 .yiv4013832528aolReplacedBody -- filtered
{panose-1:2 4 5 3 5 4 6 3 2 4;}#yiv4013832528 .yiv4013832528aolReplacedBody
filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv4013832528
.yiv4013832528aolReplacedBody filtered {font-family:Tahoma;panose-1:2 11 6 4 3
5 4 4 2 4;}#yiv4013832528 .yiv4013832528aolReplacedBody filtered
{font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv4013832528
.yiv4013832528aolReplacedBody filtered {font-family:Consolas;panose-1:2 11 6 9
2 2 4 3 2 4;}#yiv4013832528 .yiv4013832528aolReplacedBody filtered
{font-family:HelveticaNeue;panose-1:0 0 0 0 0 0 0 0 0 0;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528MsoNormal, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528MsoNormal, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody a:link, #yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528MsoHyperlink
{color:blue;text-decoration:underline;}#yiv4013832528
.yiv4013832528aolReplacedBody a:visited, #yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv4013832528
.yiv4013832528aolReplacedBody p
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528MsoAcetate, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528MsoAcetate, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528MsoAcetate
{margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msoacetate, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msoacetate, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msoacetate
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal0, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal0, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal0
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msochpdefault, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msochpdefault, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msochpdefault
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal1, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal1, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal1
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msochpdefault1, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msochpdefault1, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msochpdefault1
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal2, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal2, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal2
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal01, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal01, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal01
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal3, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal3, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal3
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msochpdefault2, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msochpdefault2, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msochpdefault2
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal11, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal11, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal11
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msochpdefault11, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msochpdefault11, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msochpdefault11
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal4, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal4, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal4
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msoacetate1, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msoacetate1, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msoacetate1
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal02, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal02, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal02
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal5, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal5, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal5
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msochpdefault3, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msochpdefault3, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msochpdefault3
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal12, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal12, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal12
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msochpdefault12, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msochpdefault12, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msochpdefault12
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal21, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal21, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal21
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal011, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal011, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal011
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal31, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal31, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal31
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msochpdefault21, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msochpdefault21, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msochpdefault21
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal111, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal111, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal111
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msochpdefault111, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msochpdefault111, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msochpdefault111
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528msohyperlink {}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528msohyperlinkfollowed
{}#yiv4013832528 .yiv4013832528aolReplacedBody span.yiv4013832528msohyperlink1
{}#yiv4013832528 .yiv4013832528aolReplacedBody
span.yiv4013832528msohyperlinkfollowed1 {}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528msohyperlink21 {}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528msohyperlinkfollowed21
{}#yiv4013832528 .yiv4013832528aolReplacedBody
span.yiv4013832528msohyperlink111 {}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528msohyperlinkfollowed111
{}#yiv4013832528 .yiv4013832528aolReplacedBody
span.yiv4013832528emailstyle18111 {}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528emailstyle2911 {}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528emailstyle3011 {}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528emailstyle451 {}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528emailstyle461 {}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528emailstyle69 {}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal6, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal6, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal6
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528msohyperlink2
{color:blue;text-decoration:underline;}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528msohyperlinkfollowed2
{color:purple;text-decoration:underline;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msoacetate2, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msoacetate2, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msoacetate2
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal03, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal03, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal03
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal7, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal7, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal7
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msochpdefault4, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msochpdefault4, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msochpdefault4
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal13, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal13, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal13
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msochpdefault13, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msochpdefault13, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msochpdefault13
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal22, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal22, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal22
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal012, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal012, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal012
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal32, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal32, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal32
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msochpdefault22, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msochpdefault22, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msochpdefault22
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal112, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal112, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal112
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msochpdefault112, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msochpdefault112, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msochpdefault112
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal41, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal41, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal41
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528msohyperlink11
{color:blue;text-decoration:underline;}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528msohyperlinkfollowed11
{color:purple;text-decoration:underline;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msoacetate11, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msoacetate11, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msoacetate11
{margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal021, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal021, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal021
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal51, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal51, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal51
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msochpdefault31, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msochpdefault31, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msochpdefault31
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal121, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal121, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal121
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msochpdefault121, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msochpdefault121, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msochpdefault121
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal211, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal211, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal211
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal0111, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal0111, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal0111
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal311, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal311, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal311
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msochpdefault211, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msochpdefault211, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msochpdefault211
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msonormal1111, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msonormal1111, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msonormal1111
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody p.yiv4013832528msochpdefault1111, #yiv4013832528
.yiv4013832528aolReplacedBody li.yiv4013832528msochpdefault1111, #yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528msochpdefault1111
{margin-right:0cm;margin-left:0cm;font-size:10.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528msohyperlink211
{color:blue;text-decoration:underline;}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528msohyperlinkfollowed211
{color:purple;text-decoration:underline;}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528msohyperlink1111
{color:blue;text-decoration:underline;}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528msohyperlinkfollowed1111
{color:purple;text-decoration:underline;}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528emailstyle181111
{color:#1F497D;}#yiv4013832528 .yiv4013832528aolReplacedBody
span.yiv4013832528emailstyle29111 {color:windowtext;}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528emailstyle30111
{color:windowtext;}#yiv4013832528 .yiv4013832528aolReplacedBody
span.yiv4013832528emailstyle4511 {color:#1F497D;}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528emailstyle4611
{color:#1F497D;font-weight:normal;font-style:normal;}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528emailstyle691
{color:#1F497D;font-weight:normal;font-style:normal;}#yiv4013832528
.yiv4013832528aolReplacedBody span.yiv4013832528BalloonTextChar
{}#yiv4013832528 .yiv4013832528aolReplacedBody span.yiv4013832528EmailStyle99
{color:#1F497D;font-weight:normal;font-style:normal;}#yiv4013832528
.yiv4013832528aolReplacedBody .yiv4013832528MsoChpDefault
{font-size:10.0pt;}#yiv4013832528 .yiv4013832528aolReplacedBody filtered
{margin:72.0pt 72.0pt 72.0pt 72.0pt;}#yiv4013832528
.yiv4013832528aolReplacedBody div.yiv4013832528WordSection1 {}#yiv4013832528
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.
--
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.
