Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / April 2006

Tip: Looking for answers? Try searching our database.

XML Schemas and linking to Excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sara Hopkins - 19 Apr 2006 02:39 GMT
I have two related (I think) questions so please bare with me.

I picked up InfoPath and encountered XML for the first time about a week ago
and have been given the task of making InfoPath forms sourced from an Excel
spreadsheet.  I am quite perplexed about how to get my Excel spreadsheet to
be an XML Schema.  MS InfoPath online training courses showed me that XML
Schema columns should display in a nice "table and column" expandable format
within the Data Source task pane.  Mine don't.

I save a sample XLS as an XML and then open the XML as a data source.  
Instead of what I expected - Named Range or Sheet Name as "table" and the
content of Cells A1 and A2 as "Columns" - I get something like this:
-Workbook
+o:DocumentProperties
+x:ExcelWorkbook
+Styles
+Worksheet
No sign of anything I recognise from the content of the spreadsheet, no
matter how deep I drill into the expandables.

I read that an XML Schema is just an XML renamed XSD, so I tried that too,
with the same result.  I tried using XL2002 and XL2003 to convert to XML/XSD,
same result again.  Can anyone help?

I don't really want to have to convert my XLS file into an XML file anyway,
my ideal would be to leave my XLS intact, attach an XML Schema to it and then
build my InfoPath forms from there.  Does anyone know if this is possible?  
If so, how?

Thanks in anticipation
Sara
Don - 19 Apr 2006 06:11 GMT
This is just as confusing to me.

Don

> I have two related (I think) questions so please bare with me.
>
[quoted text clipped - 27 lines]
> Thanks in anticipation
> Sara
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.