open Access database table in excel on the client PC

Question

0.00/5 (No votes)

See more:

Hi,

VS2010, VB.net

i have a button that is on an asp.net page.
when the button is clicked, it should pull out the data from table ABC, convert it into an .xls file and display it on the clients PC.

i am able to export the data and save the data on the server but not able to automatically open the xls file on the clients PC
Could anyone help me on this one?

thanks
Joe

Posted 26-Oct-11 22:07pm

joe_j

Add a Solution

2 solutions

Solution 1

You have to return the XLS file to your client as a stream, read the following :

http://stackoverflow.com/questions/150339/generating-an-excel-file-in-asp-net[^]

http://www.velocityreviews.com/forums/t118430-how-to-return-an-excel-file-or-excel-data-from-asp-net.html[^]

Posted 26-Oct-11 22:27pm

Mehdi Gholam

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

joe_j · Accepted Answer · 2011-11-18T02:49:00

Solution 2

well i got this done successfully.
but in a different approach.
i save all the required data in a code generated excel file in the server.
and then applied a link for the users to download the excel file.
works perfectly fine.

thanks

Posted 18-Nov-11 2:49am

joe_j