Hello Friends,
Below is a snapshot of code I use to query any excel worksheet having
tabular data.
Do somebody have idea how to query excel file if i need distinct value from
a particular column or I want to use some type of query like updated?
***************************************************************
Set Conn = New ADODB.Connection
FFULLName = PI_FileName
ConnStr = "Data Source=" & """" & FFULLName
ConnStr = ConnStr & """" & ";Extended Properties=""Excel 8.0;HDR=NO;"""
With Conn
.Provider = "Microsoft.Jet.OLEDB.4.0;"
.ConnectionString = ConnStr
.Open
End With
Set RST = New ADODB.Recordset
strQuery = "SELECT * FROM [RECEIVE$];"
RST.Open strQuery, Conn, adOpenDynamic, adLockOptimistic
***************************************************************
Do somebody have idea how to query excel file if i need distinct value from
a particular column.
(¨`·.·´¨) Keep
`·.¸(¨`·.·´¨) Smiling !!
(¨`·.·´¨)¸.·´ Upendra Singh
`·.¸.·´9910227325
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
