HMGforum.com

Do anybody know, how to export database to excel?

Regards, Marek

I think the easiest way is to open MS Excel 2003 (I believed it would be the same procedure for MS Office 2007) and do:

1. File Open
2. then on file types select dBase files (*.dbf)
3. then select the file, and excel will open that file.
4. Then do save as: Microsoft Excel Workbook (*.xls)

However if the database is from two or more files you should use HB OLE to transfer the file and format them the way you like to be.

You can use Harbour OLE also.

Kindly see \hmg\samples\ole\demo.prg

Many thanks for your answers,
Marek

To Rathinagiri:
I tried ole\demo.prg
It's very useful.
Can you tell mi if I can do it "silent" - without opening window with MS Excel?

Marek

I don't know. Let me try.

Can you help me how to open existing XLS sheet and write some data at the first empty cell in "A" column?

Don't you know where can I find something about using OLE and excel?

May be you can try using MiToprint library from jose miguel


http://www.embalajesterra.com/misdoc/ej ... NTOv23.zip


the library can export a database report to spreadsheet format

i think that a time ago Jose Miguel change to use Openoffice in place of Microsoft Office

In previous versions it use excel , may be I can find an old version for you, try it

Bruno

I have version 2.0 of MiTprinto if you like , let me know
and I send tou you by mail


Bruno

I think it doesn't have the library you mention.

Please send the code to connect to Openoffice as you mentioned.

Thanks in Advance.