Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello, I have a large amount of data contained within an XML file that needs
to be accessible by developers (for import into a data warehouse, etc) as well as business staff who require it to be in Excel format (2007) - I am wanting to dump the XML file onto an FTP site for all users to access (via a loginId). With regards to users who need to access the file as though it was Excel, I was thinking of using a generic XSLT (like the one shown on http://aspalliance.com/471_Convert_X...sing_XSL. all) to allow it to be imported neatly into Excel. However I don't really know how it all fits together - as far as I can see, the users should be able to logon to the FTP site, download the XML file (with perhaps the XSLT file), then double-click (or import) into Excel - is this possible. I was actually thinking they could download just one file (the XML file) which would contain the XSLT information inline (rather than having to download both) Is this possible - are there any samples. Many thanks Travis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|