Maybe a workaround, but it works A 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 export For a Workbook it should be: XLSW Tony 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 Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 From: 'Patti Jakusz' via RBASE-L [mailto:[email protected] <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.
