importing excel to infopath 07

[Tbarbee708]

Hello, I was trying to import an excel worksheet for use in Infopath 07 it
imports some of the form but it doesn't catch all of it or even the formulas
I have saved in the form , is it possible for info path to work with excel
correctly

 

[Ben Walters]

Hey TBarbree708,
If I'm reading this properly your trying to import an Excel based form into
InfoPath, however InfoPath is not converting all the formulas for your. If
this is the case then unfortunately you will need to recreate the formulas
in the form once you have gone through the import process.

Currently there is no direct way (without creating some custom code) for
InfoPath to work directly with Excel. Now I don't know your solution
intimately but my suggestion would be to submit your forms to a SharePoint
form library promoting the fields you needed to see in Excel to the library,
you could then view the data in excel but selecting "Actions>Open in Excel".

Hope this helps

Cheers
Ben Walters