Re: More Re: [RBASE-L] - Can't export any data

'Patti Jakusz' via RBASE-L Mon, 14 Nov 2016 06:19:06 -0800

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 Markson The Pharmacy 
Examining Board of Canada 416.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.

Re: More Re: [RBASE-L] - Can't export any data

Reply via email to