Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS file creation

Status
Not open for further replies.

SQLScholar

Programmer
Aug 21, 2002
2,127
0
0
GB
Hey all,

We currently use a really terrible peice of software to query are SQL/Access DB`s and produce scheduled reports.

The problem is that the software is expensive - AND terrible. I am thinking of starting to use DTS.

I have successfully created a report which sends and email to myself. BUT it has no file headings (i.e. the names of the columns). Without having to add to the reports a column heading union, is there any way to add the column names to the query?

Many Thanks

Dan

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!
 
Just found it out - thanks anyway

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top