Export to CSV/txt/... from QV9

[#1]

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!

[#2]

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

[#3]

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 😉

[biester]

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

[#5]

Super mega bravo!
Thank you!

Daniela

[#6]

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

[#7]

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

[biester]

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

[#9]

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

[#10]

Hi Marcelo

Did you ever resolve this issue of removing the header ?

If so how