Exporting query result into excel file

Hi i am newbie . I want to transfer the query result into excel file throgh asp code. can any one help me out.

Also how can i automate my routing task that is data in excel to be updated in the table which is in SQL server. Say x.xls is the daily file maintaned by me and i want y table in sql server to be appended once this file is saved.Writing a macro in Excel could be one of the solutions!!!sql

Exporting from snapshot data

Is there anyway possible to grab a snapshot via some vb.net or c# code and
then export it to pdf, txt, etc...?Yes,
If you've created a snapshot then you can get to the snapshot via the REnder
Method on the Reporting Services' SOAP interface.
Chapter 9¾ (Our Harry Potter Themed Chapter with Voldemort Basic.NET quips)
deals with SOAP and pages 585 - 592 - should show you all the details you
need to know about how to create a snapshot via code and also how to render
it.
Peter Blackburn
Hitchhiker's Guide to SQL Server 2000 Reporting Services
http://www.sqlreportingservices.net
"Mike H" <Mike H@.discussions.microsoft.com> wrote in message
news:62F37D51-6862-415C-9C87-FE82685FC6D3@.microsoft.com...
> Is there anyway possible to grab a snapshot via some vb.net or c# code and
> then export it to pdf, txt, etc...?sql

Export view result using transferdatabase

I am trying to export the results of a view from an .adp to an .mdb
using TransferDatabase. The code I am using is
DoCmd.TransferDatabase acExport, "Microsoft Access", _
"C:\___work\WayAhead\Implementation\XTRA_Samples.md b" _
, acTable, "x_loe_vw", "LOE_tbl"

When I run this I get an error that states
" can't find the object 'x_loe_vw'".
Yet it is defined as a view.

Any ideas?
Thanks,
JerryJer (jerry.w.black@.saic.com) writes:
> I am trying to export the results of a view from an .adp to an .mdb
> using TransferDatabase. The code I am using is
> DoCmd.TransferDatabase acExport, "Microsoft Access", _
> "C:\___work\WayAhead\Implementation\XTRA_Samples.md b" _
> , acTable, "x_loe_vw", "LOE_tbl"
> When I run this I get an error that states
> " can't find the object 'x_loe_vw'".
> Yet it is defined as a view.
> Any ideas?

The one idea I get is that you should probably post to
comp.databases.ms-access, or some other Access forum, where people
may know Access better than in this forum.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||See if specifying "acQuery" instead of "acTable" helps.
If not try posting this on comp.databases.ms-access

"Jer" <jerry.w.black@.saic.com> wrote in message
news:1118070165.662857.296420@.z14g2000cwz.googlegr oups.com...
> I am trying to export the results of a view from an .adp to an .mdb
> using TransferDatabase. The code I am using is
> DoCmd.TransferDatabase acExport, "Microsoft Access", _
> "C:\___work\WayAhead\Implementation\XTRA_Samples.md b" _
> , acTable, "x_loe_vw", "LOE_tbl"
> When I run this I get an error that states
> " can't find the object 'x_loe_vw'".
> Yet it is defined as a view.
> Any ideas?
> Thanks,
> Jerry

Export varbinary Data Types to Local PC from SQL Database

Could someone help me with writing the code to export the contents of a varbinary field in my database to make the contents be written to the local harddrive? I can do this in Visual Foxpro but my company wants it in C# and I have no clue about C#.
Thank you:eek:What do you need help doing? Are you looking for someone to write the C# program for you?

-PatP|||You know.......this is the 6th forum I have posted this question to. I must not be asking my question correctly.

I need help writing code to retrieve all my files out of an SQL IMAGE (varbinary) field and make the contents become files back on my hard drive again.|||There are 192 records. I need to retrieve the contents of all the varbinary fields and put the contents back on my hard drive. Some are .xls files, some .doc, some .txt. But, they need to come back out of SQL Server and go back to being files on my hard drive again.

export sql query result to excel spread sheet

Hi,,
I need to export a sql query result to a excel sheet. I can't use DTS. Any
simple t-sql code to do this?
ThanksHI
see this link
http://weblogs.sqlteam.com/mladenp/archive/2006/07/25/10771.aspx
regards
Vt
Knowledge is power;Share it
http://oneplace4sql.blogspot.com
"mecn" <mecn2002@.yahoo.com> wrote in message
news:uLo2uU0tHHA.3944@.TK2MSFTNGP06.phx.gbl...
> Hi,,
> I need to export a sql query result to a excel sheet. I can't use DTS. Any
> simple t-sql code to do this?
> Thanks
>
>|||it works,
Thanks a lot!!!!~
\\
"Vt" <vinu.t.1976@.googlemail.com> wrote in message
news:u52BIE1tHHA.1728@.TK2MSFTNGP06.phx.gbl...
> HI
> see this link
> http://weblogs.sqlteam.com/mladenp/archive/2006/07/25/10771.aspx
> regards
> Vt
> Knowledge is power;Share it
> http://oneplace4sql.blogspot.com
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:uLo2uU0tHHA.3944@.TK2MSFTNGP06.phx.gbl...
>> Hi,,
>> I need to export a sql query result to a excel sheet. I can't use DTS.
>> Any simple t-sql code to do this?
>> Thanks
>>
>|||Try www.sqlscripter.com to export your query to Excel.
It's free.
"mecn" wrote:
> Hi,,
> I need to export a sql query result to a excel sheet. I can't use DTS. Any
> simple t-sql code to do this?
> Thanks
>
>

export sql query result to excel spread sheet

Hi,,
I need to export a sql query result to a excel sheet. I can't use DTS. Any
simple t-sql code to do this?
ThanksHI
see this link
http://weblogs.sqlteam.com/mladenp/...7/25/10771.aspx
regards
Vt
Knowledge is power;Share it
http://oneplace4sql.blogspot.com
"mecn" <mecn2002@.yahoo.com> wrote in message
news:uLo2uU0tHHA.3944@.TK2MSFTNGP06.phx.gbl...
> Hi,,
> I need to export a sql query result to a excel sheet. I can't use DTS. Any
> simple t-sql code to do this?
> Thanks
>
>|||it works,
Thanks a lot!!!!~
\\
"Vt" <vinu.t.1976@.googlemail.com> wrote in message
news:u52BIE1tHHA.1728@.TK2MSFTNGP06.phx.gbl...
> HI
> see this link
> http://weblogs.sqlteam.com/mladenp/...7/25/10771.aspx
> regards
> Vt
> Knowledge is power;Share it
> http://oneplace4sql.blogspot.com
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:uLo2uU0tHHA.3944@.TK2MSFTNGP06.phx.gbl...
>

export sql query result to excel spread sheet

Hi,,
I need to export a sql query result to a excel sheet. I can't use DTS. Any
simple t-sql code to do this?
Thanks
it works,
Thanks a lot!!!!~
\\
"Vt" <vinu.t.1976@.googlemail.com> wrote in message
news:u52BIE1tHHA.1728@.TK2MSFTNGP06.phx.gbl...
> HI
> see this link
> http://weblogs.sqlteam.com/mladenp/archive/2006/07/25/10771.aspx
> regards
> Vt
> Knowledge is power;Share it
> http://oneplace4sql.blogspot.com
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:uLo2uU0tHHA.3944@.TK2MSFTNGP06.phx.gbl...
>