MS Access -> Listview -> Excel

[ExDelphi]

Hi All
I am fairly new to VB.Net, and have gotten stuck with an invoicing
application. My database (Access 2000 / 2003) is used to store records of our
products, customers, suppliers etc. The user can select customer details
which form the proposal / invoice header. The user can also select certain
products which can be added to the proposal "dataset". The selected product
items are displayed in a listview control. My question is as follows. How do
I write the items in the listview control to an Excel spreadsheet?

Any help will be greatly appreciated

[CT]

I'd go with one of the report products that can save to Excel. Another
option is to write to a text file, in XML or CSV format, which can be opened
in Excel?

--
Carsten Thomsen
Enterprise Development with VS .NET, UML, AND MSF
http://www.apress.com/book/bookDisplay.html?bID=105
Communities - http://community.integratedsolutions.dk

"ExDelphi" <Ex******@discussions.microsoft.com> wrote in message
news:8E**********************************@microsof t.com...

Hi All
I am fairly new to VB.Net, and have gotten stuck with an invoicing
application. My database (Access 2000 / 2003) is used to store records of
our
products, customers, suppliers etc. The user can select customer details
which form the proposal / invoice header. The user can also select certain
products which can be added to the proposal "dataset". The selected
product
items are displayed in a listview control. My question is as follows. How
do
I write the items in the listview control to an Excel spreadsheet?

Any help will be greatly appreciated

[Jan]

You have few components on the market which support XLS export.

For example, our ExcelLite Free is a free .NET component that can read /
write both XLS and CSV files. You can use it in a commercial applications;
it is only limited to max 150 rows per sheet. You can download it here:
http://www.gemboxsoftware.com/ExcelLiteFree.htm If your worksheet grows in
size, you can easily update to ExcelLite Professional.

Jan

"ExDelphi" <Ex******@discussions.microsoft.com> wrote in message
news:8E**********************************@microsof t.com...

Hi All
I am fairly new to VB.Net, and have gotten stuck with an invoicing
application. My database (Access 2000 / 2003) is used to store records of
our
products, customers, suppliers etc. The user can select customer details
which form the proposal / invoice header. The user can also select certain
products which can be added to the proposal "dataset". The selected
product
items are displayed in a listview control. My question is as follows. How
do
I write the items in the listview control to an Excel spreadsheet?

Any help will be greatly appreciated