Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to export a table object to a CSV or TXT file. It never displays an error message, but the file never seems to be created. Instead, after pressing the 'Save' button, my table object reappears with a big cross in it.
Exporting (Send to Excel) works fine, but has the obvious limitations of using Excel, so I'd prefer not to use this. For large quantities of data, I'd like to use Access instead.
Please could anyone tell me if I'm doing something wrong, of if it's a bug in (my) QV9?
Thanks!
Hello!
I have just the same problem:
Sub ExportVarie
set obj = ActiveDocument.GetSheetObject("CH01")
Obj.ExportHTML("C:\test.htm") 'This instruction work
Obj.Exportxml("C:\test.xlsx") 'This instruction work
Obj.ExportBiff("c:\Test.xls") 'This does nothing
Obj.ExportTXT("C:\test.csv") 'This gives me error
end sub
Obj.ExportBiff("c:\Test.xls") This statement proved by q8.5 works!
At this point is clearly a bug of QV9!
I have not installed the SR1 because I tried
and there are other bugs so I prefer to wait.
Do you know if by chance this hole had been arranged with the SR1 ????? [:'(]
Daniela
No, it doesn't seem to make a difference for me.
But, SR1 has improved quite a few front-end bugs in the least, so you never know what might have been done on the back end 😉
Everything is working fine here with me with QV 9 SR1.
In the macro, note that ExportTxt is no more supported obviously. Just use Export. You have a second parameter there, the delimiter, so use:
Obj.Export "C:\test.txt",";"
Obj.Export "C:\test.csv",","
Rgds,
Joachim
Super mega bravo!
Thank you!
Daniela
when you use this export from a Table object (That doesnt display duplicates) what data is exported, the Distinct Values or the entire Source Table.
Colin R
Joachim,
I tested your code and it works, but i have another issue. Is there a way to create the text file without the first line (a header containing the columns names)?
Tks,
Marcelo
Marcelo,
AFAIK these exports types are always made with headers, no possibility (at least none that I knew of) to suppress it. You would have to do it by yourself (a macro) if you really need it.
Rgds,
Joachim
Hi, Joachim!
I guess there is no other way. It would be very simple if the STORE command had this option (create txt files without the header), but, if there is not this option, let's go to the macro.
Thanks a lot.
Marcelo
Hi Marcelo
Did you ever resolve this issue of removing the header ?
If so how