Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > export data to Excel

Reply
Thread Tools

export data to Excel

 
 
atse
Guest
Posts: n/a
 
      10-06-2003
Sorry, I copy and paste by mistake only. It wouldn't be there in my file.
Any other problem? Thanks
Atse


"Ray at <%=sLocation%>" <myfirstname at lane 34 . komm> wrote in message
news:(E-Mail Removed)...
> You have an erroneous ' in your connection string there, right after D:\.
>
> Ray at home
>
> "atse" <(E-Mail Removed)> wrote in message
> news:Ng2gb.34595$ko%(E-Mail Removed) le.rogers.com...
>
> >
> > Microsoft JET Database Engine error '80040e37'
> >
> > The Microsoft Jet database engine could not find the object 'xls'. Make

> sure
> > the object exists and that you spell its name and the path name

correctly.
> >
> > /list_item.asp, line 9
> >
> >
> >
> > the connection is below:
> >
> > con_xls="Provider=Microsoft.Jet.OLEDB.4.0;Data

> Source=D:\'test.xls;Extended
>
>



 
Reply With Quote
 
 
 
 
Ray at
Guest
Posts: n/a
 
      10-06-2003
IIRC, you were using a "file" variable in your querystring. And I assume
that was used in building your connection string. So, it sounds to me that
the variable was empty.

Response.Write YourConnectionStringVariable
Response.End

Ray at home

"atse" <(E-Mail Removed)> wrote in message
news:wh5gb.234912$(E-Mail Removed). cable.rogers.com...
> Sorry, I copy and paste by mistake only. It wouldn't be there in my file.
> Any other problem? Thanks
> Atse
>
>
> "Ray at <%=sLocation%>" <myfirstname at lane 34 . komm> wrote in message
> news:(E-Mail Removed)...
> > You have an erroneous ' in your connection string there, right after

D:\.
> >
> > Ray at home
> >
> > "atse" <(E-Mail Removed)> wrote in message
> > news:Ng2gb.34595$ko%(E-Mail Removed) le.rogers.com...
> >
> > >
> > > Microsoft JET Database Engine error '80040e37'
> > >
> > > The Microsoft Jet database engine could not find the object 'xls'.

Make
> > sure
> > > the object exists and that you spell its name and the path name

> correctly.
> > >
> > > /list_item.asp, line 9
> > >
> > >
> > >
> > > the connection is below:
> > >
> > > con_xls="Provider=Microsoft.Jet.OLEDB.4.0;Data

> > Source=D:\'test.xls;Extended
> >
> >

>
>



 
Reply With Quote
 
 
 
 
atse
Guest
Posts: n/a
 
      10-06-2003
I did try that too. It displays a correct string.

"Ray at <%=sLocation%>" <myfirstname at lane 34 . komm> wrote in message
news:(E-Mail Removed)...
> IIRC, you were using a "file" variable in your querystring. And I assume
> that was used in building your connection string. So, it sounds to me

that
> the variable was empty.
>
> Response.Write YourConnectionStringVariable
> Response.End
>
> Ray at home
>
> "atse" <(E-Mail Removed)> wrote in message
> news:wh5gb.234912$(E-Mail Removed). cable.rogers.com...
> > Sorry, I copy and paste by mistake only. It wouldn't be there in my

file.
> > Any other problem? Thanks
> > Atse
> >
> >
> > "Ray at <%=sLocation%>" <myfirstname at lane 34 . komm> wrote in message
> > news:(E-Mail Removed)...
> > > You have an erroneous ' in your connection string there, right after

> D:\.
> > >
> > > Ray at home
> > >
> > > "atse" <(E-Mail Removed)> wrote in message
> > > news:Ng2gb.34595$ko%(E-Mail Removed) le.rogers.com...
> > >
> > > >
> > > > Microsoft JET Database Engine error '80040e37'
> > > >
> > > > The Microsoft Jet database engine could not find the object 'xls'.

> Make
> > > sure
> > > > the object exists and that you spell its name and the path name

> > correctly.
> > > >
> > > > /list_item.asp, line 9
> > > >
> > > >
> > > >
> > > > the connection is below:
> > > >
> > > > con_xls="Provider=Microsoft.Jet.OLEDB.4.0;Data
> > > Source=D:\'test.xls;Extended
> > >
> > >

> >
> >

>
>



 
Reply With Quote
 
Greg Griffiths
Guest
Posts: n/a
 
      10-07-2003
also worth checking out http://www.greggriffiths.org/webdev/both/excel/

atse wrote:

> Hi experts,
>
> I retrieve data from the database and display on ASP, then I export these
> data to a file, like Excel (the best) or text file. Is it possible? I think
> it is possible, but how can I do that? Thanks for any help.
>
> Atse


 
Reply With Quote
 
Chris Baldwin
Guest
Posts: n/a
 
      10-08-2003
"atse" <(E-Mail Removed)> wrote in message news:<7Vnfb.206907$(E-Mail Removed) .cable.rogers.com>...
> Hi experts,
>
> I retrieve data from the database and display on ASP, then I export these
> data to a file, like Excel (the best) or text file. Is it possible? I think
> it is possible, but how can I do that? Thanks for any help.
>
> Atse


Atse,

SoftArtisans ExcelWriter can do exactly that... database-to-Excel web
reports, and you don't need to have Excel installed on the web server.

http://officewriter.softartisans.com/

-chris
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export to Excel (Default File Type - Excel) =?Utf-8?B?SGVtYW50IFNpcGFoaW1hbGFuaQ==?= ASP .Net 15 05-21-2009 12:01 PM
Export to excel in asp.net using excel template Grey ASP .Net 4 10-17-2007 08:08 AM
using Microsoft Excel image for Export to Excel button =?Utf-8?B?U3JpZGhhcg==?= ASP .Net 0 12-09-2005 08:58 PM
Export data from grid to Excel Deva ASP .Net 1 01-13-2004 07:54 AM
export data from an asp .net web form to Excel Joy ASP .Net 2 08-22-2003 08:45 AM



Advertisments