Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
nhojnesnah
 
Posts: n/a
Default Can I save the *.xsd schema that Excel infers from my xml source ?

I would like to be able to edit/re-use the schema that Excel inferred when I
asked it to map my source xml file.
Excel seems to have made a better job of producing an appropriate map of my
data files than my best efforts in Notepad, but I can see no way to save this
map out as a new xml schema.
Is there a way ???

  #2   Report Post  
Jan Karel Pieterse
 
Posts: n/a
Default Can I save the *.xsd schema that Excel infers from my xml source ?

Hi Nhojnesnah,

I would like to be able to edit/re-use the schema that Excel inferred when I
asked it to map my source xml file.
Excel seems to have made a better job of producing an appropriate map of my
data files than my best efforts in Notepad, but I can see no way to save this
map out as a new xml schema.
Is there a way ???


There is an XML toolbox available at MSDN:

http://www.microsoft.com/downloads/d...2C2C-4870-A189
-D47A5D7FFEB3&displaylang=en

one of the options is to infer a schema based on the selection.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro excel save mrbalaje Excel Discussion (Misc queries) 1 May 12th 05 06:27 PM
How save a lotus 2.2 file in excel and to open it in excel and pe. bird New Users to Excel 0 February 26th 05 01:57 AM
How do I save a worsheet from Excel 2002, for a user with Excel 2. vkirkman Excel Discussion (Misc queries) 1 February 23rd 05 03:19 PM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 08:05 PM
How do I save a record from an excel template to a database in a . Fred Smith Excel Discussion (Misc queries) 1 November 30th 04 01:49 PM


All times are GMT +1. The time now is 10:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"