http://support.microsoft.com/default.aspx?scid=kb;en-us;321686&Product=sql2k states:

When the Jet Provider determines that an Excel column contains mixed text and numeric data, the Jet Provider selects the "majority" data type and returns non-matching values as...

Additionally, you can use an ADO recordset object combined with a file system object in an ActiveX script in DTS, which you can then schedule, to write the result of your query to...

We have a scheduled DTS job that uses the ADO Recordset Object in an ActiveX Script to parse worksheets in an excel workbook and load the data into SQL Server.

The...

Guess what I found:

http://www.sqlservercentral.com/columnists/sjones/codingstandardspart2formatting.asp

This article seems to be a good start.

If anyone knows about anything else, please let me know.

Thanks Scorpion_66, this query worked ...

quote:

---

How about:

SELECT IMCL_SAMPLE.SERV_RQST_ID, COUNT(IMCL_SAMPLE.SERV_RQST_ID) AS SAMPLE_CNT

FROM

(SELECT DISTINCT Top 100 percent...