MS Access -> Listview -> Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
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
 
Back
Top