Yes very good!

But people who are new to this community don't know about those guidlines and

they are in a middle of a problem and just waiting for us to to...

Let's start with the orginal question:

"Hello Experts,

Actually I have a Dynamically generated table with the columns names like Q1, Q2.... up to any number don't know. I just wanted todo...

"Surely, if you have a column you do not wish to display in an XML Document, and it's always going to be called Id, or C1, or whatever - rather...

This may work for you:

Replace table data with your tabel

In your select statement you can create a temp table.

declare @column_num int

declare @column_max int

declare @k int

declare @columnname varchar(100)

declare...

"Instead of passing a file location, what you might want to do is have the .NET app upload the file to a standard location, and give it a unique name...

"I have windows 2003 server (enterprise edition - 32 bit & SP2) with MS Sql 2000 server installed. I wanted to establish ODBC connectivity from windows XP machine to this...

Adam

I have converted from SQL 2000 to 2005 32 bit and 64 bit including DTS pagage.

I was in the same situation as you (rewrite the stuff in SSIS or VB.net...

"The path of the file is passed through a FileOpenDialiog in vb.net" ?

May be I don't exactly understand what you will acomplish but:

If it is a portable solution I save...

Junior_DB

What do you want as the end result? Is it an application which will produce excelfiles

with different selections SQL from your database per day to different users?

Or is it add...

"Hello - I've done a lot of Excel importing into SQL and it's a real pain. Sometimes values simply don't get imported, and other times it makes a guess at...

To solve a situation you describe is exactly what I do as a main part for living.

There are many solutions but I to be short don't use DTS or SSIS.

I...

"Jeez... doesn't anyone know how to use "Get External Data" on a simple view anymore? "

I like that.

The problem is however bigger. In my part of the world (Sweden)...

I also agree.

What are the users (customers) of the data needs in reporting and analysing data (to make information)?

I make a difference between a report (something which is stable over...

OK

You are doing what I am doing. I dont use SSIS at all.

VBA in Excel works very fine. I use remote SQL to work across the internal net

in some companies...

Have you found a solution yet?

There is a lot of suggestions on the net.

This works for me:

etc

' Remember...