Ask a Question Sign up for Free 122 Experts currently online. Ask Questions for Free!

Exporting Data from a InfoPath Form - Microsoft InfoPath

Is there any way to get around the 256 column limitation on the export of InfoPath Form data to an Excel file, or will I need to export to a db? When exporting data from an InfoPath form, can you set up and save templates for the specific fields to ...

Results 1 to 3 of 3

  1. #1

    Exporting Data from a InfoPath Form

    Is there any way to get around the 256 column limitation on the export
    of InfoPath Form data to an Excel file, or will I need to export to a
    db?

    When exporting data from an InfoPath form, can you set up and save
    templates for the specific fields to be exported? It is a pain to
    have to select the fields you want using the export wizard since the
    export feature exports all fields in the form.
    Jill
  2. #2

    Re: Exporting Data from a InfoPath Form

    I am personally haven't used the export feature enough to be of assistance here. Though I would assume that if there is a strict 256 column limitation that one way to work around it, although it may be a lame workaround, is to export several times with different sets of data each time, then combine them in Excel. Exporting to a DB may work, but again, I'm won't be of any help there.

    Microsoft has published its schema for Excel and other Office apps. It is possible that you could use that schema to create your own Excel file right from within InfoPath. I've never tried this. But in concept it should work.

    I don't believe that you can choose which fields to be exported, like you can do for choosing which columns are displayed on SharePoint.

    --
    Greg Collins [InfoPath MVP]
    Please visit: http://www.InfoPathDev.com



    "Jill Adams" <com> wrote in message news:google.com...
    Is there any way to get around the 256 column limitation on the export
    of InfoPath Form data to an Excel file, or will I need to export to a
    db?

    When exporting data from an InfoPath form, can you set up and save
    templates for the specific fields to be exported? It is a pain to
    have to select the fields you want using the export wizard since the
    export feature exports all fields in the form. Can it be made to export only
    Fields that are populated?
    Greg
  3. #3

    Re: Exporting Data from a InfoPath Form

    Invert the problem: If you have Excel 2003 with XML support, you can open an
    XML file in Excel and set up an XML map. You may be able to only import one
    file at a time this way, but you should be able to save the mapping.


    "Jill Adams" <com> wrote in message
    news:google.com... 


    Matthew

Similar Threads

  1. Loading Data into InfoPath Form via external COM
    By Matthew in forum Microsoft InfoPath
    Replies: 2
    Last Post: 07-28, 11:35 AM
  2. Replies: 2
    Last Post: 07-01, 09:49 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100