<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>SQL Database Integration</title><link>https://www.infopathdev.com:443/forums/47.aspx</link><description>For questions concerning issues in the integration of SQL and Microsoft InfoPath.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Not all Infopath fields can be submitted to a database</title><link>https://www.infopathdev.com:443/forums/thread/38472.aspx</link><pubDate>Mon, 16 Feb 2009 23:08:02 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:38472</guid><dc:creator>nucel</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/38472.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=38472</wfw:commentRss><description>&lt;p&gt;I have a very large document that I created in infopath previously.&amp;nbsp; Now I have the need to take and convert that document so that it submits the data to a database, however, some of my InfoPath fields are designed to allow for verbose descriptions and dialog which typically exceeds 250 charactes.&amp;nbsp; Since infopath does not allow you to integrate fields of this size with an access database as the datasource, is there a way to write a script or something that when the data is submitted to the database, that the remaining information not contained in the database can still be saved to an XML file that is still associated with that access record?&amp;nbsp; Then, if that record were to be opened, could the form then populate with all of the information from the access database AND the XML file?&lt;/p&gt;</description></item></channel></rss>