Page 1 of 1

copy or download tabledefinition into excel

Posted: Thu Jul 21, 2005 12:42 pm
by userds
Hi,

Is there any way to copy or download the table definition into excel format. Please let me know.

Thanks.

Posted: Thu Jul 21, 2005 2:00 pm
by kduke
Ray posted code to take DS_METADATA and save it as XML. That should get you close. Either that or you could save as comma delimited and import that into Excel.

Posted: Thu Jul 21, 2005 2:21 pm
by pnchowdary
Hi Kim,
Either that or you could save as comma delimited
Could you please tell me how to save the metadata in a comma delimited format ?

Posted: Thu Jul 21, 2005 3:02 pm
by kduke
Do an exact search for DS_METADATA where Ray is the poster. Modify his code.

Posted: Thu Jul 21, 2005 3:46 pm
by pnchowdary
Hi Kim,

I couldnt find the topic which contains code to extract metadata from DS_METADATA posted by ray. I did find a link in one of the posts, but it says that the topic no longer exists. Anyway, thanks for your help.

Posted: Thu Jul 21, 2005 4:43 pm
by kduke
viewtopic.php?t=89234 is where it is.

Posted: Thu Jul 21, 2005 4:50 pm
by pnchowdary
Hi Kim,

Thank you very much for the link. Somehow I missed it in my search, sorry for the trouble.