473,327 Members | 2,090 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

MS Access -> Listview -> Excel

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

Sep 26 '05 #1
2 2110
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

Sep 26 '05 #2
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

Sep 27 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

38
by: Remco Groot Beumer | last post by:
Hello, I'm trying to decide if the following situation would be workable: Generate an MS Access Front End (which will run localy on client computers), which will link to a DBMS (SQL server or...
3
by: Gaffar | last post by:
Hello, how to export ms-access tables information to excel sheet using ASP. please give sample code. it is very urgent to me or if u have no idea please give any news group to solve my...
7
by: taylor.bryant | last post by:
I am running: Win XP SP2 Excel 2002, Access 2002 (Office XP SP3) Using Visual Basic (not VB.NET) At one point (prior to XP SP2?!? - I can't pin it down), this did not happen and I was easily...
2
by: ExDelphi | last post by:
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...
0
by: Steve1974 | last post by:
Hi All I am currently using Access to output to excel. The creation of the worksheet goes ok, and then I have a piece of code (recorded from an Excel macro) to create pick lists for two columns...
0
by: JFKJr | last post by:
Hello everyone! I am trying to export Access table data into Excel file in such a way that the table field names should be in the first line of each column in excel file followed by field data, and...
2
by: eko99312 | last post by:
Dear All, As you know that input data on excel is easy than access, you can simple click the date that you prefer and input the value that you want. For example : Consider that the month that I...
0
by: Aravind555 | last post by:
Hi, I like to update access data base from excel , based on primary key. also i like to know how to get customized report(query) in Excel where i may need to do only refresh in excel Thanks...
0
by: neerja khattar | last post by:
Access form having filtering criteria.It generates a query so I want that query to show the output in excel report. How Should I show access form result on excel report
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.