Hey guys - data export via crystal report (MSSQL -> XLS) programmatically.
Is it possible?
I am using MS SQL and Visual Studio 2005 (VB.NET exclusive).
I want to export data from my MS SQL database to a XLS file.
If so, i would appreciate any pointers on how to go about doing it - i'm completely clueless in this aspect.

EDIT : I just read a method of data export via DGV printing, does anyone know how it works/whether i can use it with VS2005?
I read the tutorial here: http://social.msdn.microsoft.com/Forums/en/vbgeneral/thread/a6927874-ad8a-4fd7-8619-7f395fe32644/
and it just won't compile for me.

Thanks,
gnxc.

Hi gnxc,

These are two links show how to export data from data base to excel:
http://msdn.microsoft.com/en-us/library/aa192473(office.11).aspx.

http://msdn.microsoft.com/en-us/library/aa168463(office.11).aspx.

You referenced a thread and said the code in that thread cannot compile on your machine. You need to modify some parameters, such as connection string or command text to suit your case.

Regards,
Aland Li

---

Please mark the replies as answers if they help and unmark if they don't. This can be beneficial to other community members reading the thread.

Bump, help would be appreciated!

Hi gnxc,

These are two links show how to export data from data base to excel:
http://msdn.microsoft.com/en-us/library/aa192473(office.11).aspx.

http://msdn.microsoft.com/en-us/library/aa168463(office.11).aspx.

You referenced a thread and said the code in that thread cannot compile on your machine. You need to modify some parameters, such as connection string or command text to suit your case.

Regards,
Aland Li

---

Please mark the replies as answers if they help and unmark if they don't. This can be beneficial to other community members reading the thread.

Thank you, going to try it out now.