Pulling data from WSS via Excel

[Nock]

Hi, when I import data from WSS via Excel's Import External Data>Data
Retrieval Services>WSS, all the free text based fields have HTML tags
throughout. Given that I'm pulling out large amounts of data for reporting
purposes, how best can I remove these references? Is there another or better
way to extract the project related information? ie. Issues, risks, Work
Status etc?

Thanks in advance,

Nock

 

[Rod Gill]

Hi,

Last time I did this I created Views in SQL Server that showed what I
wanted, then Imported directly into Excel. I used Replace commands in VBA
to remove the html tags.

 

[Mei Yoong]

hi nock,

i have a quiry for you, how do u import the data via excel? do you need to
create the datasource in ODBC setting? need to select what driver? coz i
have the wss database but do not know how to pump the data in excel.
appreciate your guidance on this. thanks

rgds
Mei Yoong