InfoPath Dev

I have been unexpectedly thrust into the Infopath/SharePoint world, and my first project deadline is rapidly approaching.

I have a lengthly, complex survey that I built in InfoPath.  The survey will be accessed through SharePoint, and I have been asked to provide the data in an access database.  I know I can set up an access view in SP, but that requires all fields be exported to the SP library.  So, my question is, what are my options for getting the data into SP without having to reproduce the 10 page survey?  Any suggestions would be very appreciated.

 

Look at Publishing your form into Sharepoint (file-pub) it will offer you to create a file to give to the Sharepoint admin to deploy, when deployed it will create the columns you specify in the dialog box in Infopath as Content-Type, then you can add the content type to a list and the columns will be usable in the list, no column to add manually.

When I select Publish, I then select 'To a SharePoint server', then it asks me for the location of the SharePoint site, then the option of Document Library or Site Conten Type, the Create new library or Update existing library, then it asks me to manually select all of the columns to include in SharePoint.  Is this what you are referrgin to?

If I have 100 fields, will the browser window scroll to include all of the fields?

Am newbie too and today looks liek a bank holiday on this forum ;-0 but that's what I did refer to. In your case, it sounds like you just want to create all the columns so you can chose the option "Create new library" this way it will create the columns in the library itself (not content type re-usable). To your question : will the 100 columns fit in a view, yes it may/can/will but it will be pretty uggly, you may keep the default view "all" to display all the columns for maintenance but what you want is to create other views filtered by criterias and displaying only the important fields (eg if you have a survey of general IT, you can create a view "hardware" that only shows columns regarding HW and not software columns. just an idea...