Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
get data and field name using querytables
Set rs = db.OpenRecordset("select * from tbl")
Set qt = sht.QueryTables.Add(rs, sht.[a1]) qt.Refresh 1 in that case, field name occur, that good. but a name is made(ex:ExternalData1), that no good. And CopyFromRecordset method doesn't bring the field name. i want to write in that sheet with only data and field name using querytables. *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculated field based on data field | Excel Discussion (Misc queries) | |||
Pivot Field in Field List but Not Source Data | Excel Discussion (Misc queries) | |||
Click in one field and data presented in another field | Excel Discussion (Misc queries) | |||
data in primay field changed however subsequent field does not upd | Excel Discussion (Misc queries) | |||
Can you use QueryTables & iqy file to post web data? | Excel Programming |