Thank you. I will try this tomorrow.
It did finally download in Excel, but I get that Access Violation error and
then later I got a message saying Do you Want to Save Book1. It's crazy. I
know tech support is no longer available for it so I will need a workaround.
Patti
From: Buddy Walker <[email protected]>
To: [email protected]
Sent: Tuesday, November 8, 2016 6:11 PM
Subject: RE: More Re: [RBASE-L] - Can't export any data
#yiv5408758975 #yiv5408758975 -- _filtered #yiv5408758975 {panose-1:2 4 5 3 5 4
6 3 2 4;} _filtered #yiv5408758975 {font-family:Calibri;panose-1:2 15 5 2 2 2 4
3 2 4;} _filtered #yiv5408758975 {font-family:HelveticaNeue;panose-1:0 0 0 0 0
0 0 0 0 0;}#yiv5408758975 #yiv5408758975 p.yiv5408758975MsoNormal,
#yiv5408758975 li.yiv5408758975MsoNormal, #yiv5408758975
div.yiv5408758975MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv5408758975 a:link,
#yiv5408758975 span.yiv5408758975MsoHyperlink
{color:blue;text-decoration:underline;}#yiv5408758975 a:visited, #yiv5408758975
span.yiv5408758975MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv5408758975 p
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv5408758975
p.yiv5408758975msonormal0, #yiv5408758975 li.yiv5408758975msonormal0,
#yiv5408758975 div.yiv5408758975msonormal0
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv5408758975
p.yiv5408758975msonormal, #yiv5408758975 li.yiv5408758975msonormal,
#yiv5408758975 div.yiv5408758975msonormal
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv5408758975
p.yiv5408758975msochpdefault, #yiv5408758975 li.yiv5408758975msochpdefault,
#yiv5408758975 div.yiv5408758975msochpdefault
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv5408758975
span.yiv5408758975msohyperlink {}#yiv5408758975
span.yiv5408758975msohyperlinkfollowed {}#yiv5408758975
span.yiv5408758975emailstyle18 {}#yiv5408758975 p.yiv5408758975msonormal1,
#yiv5408758975 li.yiv5408758975msonormal1, #yiv5408758975
div.yiv5408758975msonormal1
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv5408758975
span.yiv5408758975msohyperlink1
{color:blue;text-decoration:underline;}#yiv5408758975
span.yiv5408758975msohyperlinkfollowed1
{color:purple;text-decoration:underline;}#yiv5408758975
span.yiv5408758975emailstyle181 {color:#1F497D;}#yiv5408758975
p.yiv5408758975msochpdefault1, #yiv5408758975 li.yiv5408758975msochpdefault1,
#yiv5408758975 div.yiv5408758975msochpdefault1
{margin-right:0in;margin-left:0in;font-size:10.0pt;}#yiv5408758975
span.yiv5408758975EmailStyle29 {color:windowtext;}#yiv5408758975
.yiv5408758975MsoChpDefault {font-size:10.0pt;} _filtered #yiv5408758975
{margin:1.0in 1.0in 1.0in 1.0in;}#yiv5408758975 div.yiv5408758975WordSection1
{}#yiv5408758975 Patti Have you tried using the UNLOAD DATA OUT
myCSVfile.CSV UNLOAD DATA FOR tablename USI columnList AS CSV WHERE
yourWhereClause OUT TERM This won’t give you the Column Names but you can
highlight and copy the columNames from the above UNLOAD. Open Excel and then
open the csv file. Insert a row in Excel and then paste the columnNames. Now
you can save as a xls/xlsw or csv. This should take a lot less time than
waiting 10 minutes and give you a work around until you purchase updated
version of R:Base. Buddy From: 'Patti Jakusz' via RBASE-L
[mailto:[email protected]]
Sent: Tuesday, November 8, 2016 4:39 PM
To: [email protected]
Subject: Re: More Re: [RBASE-L] - Can't export any data And now, 10 minutes
later, it gave me the file anyway. I give up. I hope to be buying the new
version of Rbase soon anyway. Patti From: Patti Jakusz <[email protected]>
To: "[email protected]" <[email protected]>
Sent: Tuesday, November 8, 2016 4:25 PM
Subject: More Re: [RBASE-L] - Can't export any data I still get the error
message, but now I get it 90 minutes later, after it pretended to export
everything.Patti From: 'Patti Jakusz' via RBASE-L <[email protected]>
To: "[email protected]" <[email protected]>
Sent: Tuesday, November 8, 2016 2:58 PM
Subject: Re: [RBASE-L] - Can't export any data Your suggestion of trying the
where clause is what did it though. I copied that from something I was doing
earlier so I knew it worked. But I always have to change the date format when
I export into excel and I forgot about doing it in the where clause too. Patti
From: karentellef via RBASE-L <[email protected]>
To: [email protected]
Sent: Tuesday, November 8, 2016 2:53 PM
Subject: Re: [RBASE-L] - Can't export any data That wouldn't have occurred to
me to suggest!
Karen -----Original Message-----
From: 'Patti Jakusz' via RBASE-L <[email protected]>
To: rbase-l <[email protected]>
Sent: Tue, Nov 8, 2016 1:51 pm
Subject: Re: [RBASE-L] - Can't export any dataOMG! I changed the date format
and didn't change it in my where clause. Thank
you!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! From: 'Patti Jakusz' via RBASE-L
<[email protected]>
To: "[email protected]" <[email protected]>
Sent: Tuesday, November 8, 2016 2:49 PM
Subject: Re: [RBASE-L] - Can't export any data Yes, the where clause is fine.
I can try to create another table using it and export the other table.Patti
From: karentellef via RBASE-L <[email protected]>
To: [email protected]
Sent: Tuesday, November 8, 2016 2:45 PM
Subject: Re: [RBASE-L] - Can't export any data Whew, that's some "where"
clause!!! Have you tried copy/paste of that where clause and run it from the
R> prompt as a "browse"? Do you get all your data up that way?
Karen -----Original Message-----
From: 'Patti Jakusz' via RBASE-L <[email protected]>
To: rbase-l <[email protected]>
Sent: Tue, Nov 8, 2016 1:36 pm
Subject: Re: [RBASE-L] - Can't export any dataI'm not using the Wizard, but I
am using the Gateway interface screen. I tried to use the wizard, but there's
no option for CSV files in it. I attached a snip of the screen. Maybe
there's a time limit on Gateway and I have to buy the new version of Rbase???
Patti From: Javier Valencia <[email protected]>
To: [email protected]
Sent: Tuesday, November 8, 2016 2:25 PM
Subject: RE: [RBASE-L] - Can't export any data Are you using the Gateway
Wizard or a command file? If it is the second, maybe you can post the code and
we might be able to figure out the issue. I export all the time using both
methods without any issues. Javier, Javier Valencia, PEO: 913-829-0888H:
913-397-9605C: 913-915-3137 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. --
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.
