Hi Ayush,
This doesn't help. I've got the correct code:
"Select Distinct [Market] from [Sheet1$A1:D5000]"
or
"SELECT DISTINCT [Column Heading] FROM TableName ORDER BY [ColumnHeading];",
(¨`·.·´¨) Keep
`·.¸(¨`·.·´¨) Smiling !!
(¨`·.·´¨)¸.·´ Upendra Singh
`·.¸.·´9910227325
On 23 December 2010 2
Dear Upendra,
Well, if your code is working fine to query excel fileYou can use
"Select distinct * from [RECEIVE$] " to pull distinct data from the column.
Not sure if it will help you. Write back in case you need something else.
Best Regards,
Ayush Jain
Microsoft MVP
--
-
