database Query result in excel spread sheet

  • Thread starter Thread starter krish pat via .NET 247
  • Start date Start date
K

krish pat via .NET 247

(Type your message here)

--------------------------------
From: krish pat

Hi

i have just started using .net as my interface development tool. i have a table name EMP, how do i convert the table/query result into excel using C# OLEDb connection.

thanks in advance
 
¤ (Type your message here)
¤
¤ --------------------------------
¤ From: krish pat
¤
¤ Hi
¤
¤ i have just started using .net as my interface development tool. i have a table name EMP, how do i convert the table/query result into excel using C# OLEDb connection.
¤

In what type of database does the table EMP reside?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Hi,

In a case of SQL Server, you could use SQL DTS to do this. I think Access
has export feature as well. If you need to do it other way, using code, then
I have .NET managed component, which allows to export data from
DataSet/DataTable into native and XML Excel formats without using any
providers. If you are interested in it, let me know.
 
Val Mazur -

I sure could use the managed component you describe.

my email address is dukecarey_at_hotmail.com

Thanks in advance.

Val Mazur said:
Hi,

In a case of SQL Server, you could use SQL DTS to do this. I think Access
has export feature as well. If you need to do it other way, using code, then
I have .NET managed component, which allows to export data from
DataSet/DataTable into native and XML Excel formats without using any
providers. If you are interested in it, let me know.
Click to expand...
 
Back
Top