Discussion Locked

Infopath and Excel

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I've been having a play with Infopath & wondered if anyone had worked out how to get it to send information to an Excel database?
I love the look & feel of the forms, but need Excel to analyse the returned info. The idea being that we use an email based form in inforpath that is returned & the data transferred to an Excel workbook.
So.. now I'm stuck. My brain hurts & I'm after the easy answer s I obviously can't find the 'right' words to ask the Infopath help...
Can anyone offer any help?

4 replies

by kpaulson

Sorry to bother but I have what I think is a very simple problem. I have Infopath, 2003, but I do not have Sharepoint. I created a simple yes no questionnaire using Infopath. This form is not going to be on a website. It will be used locally on our intranet.

What I have found out is that I can save the forms as form1 from2 and so on. After that I can then export to excel by selecting all the forms using Infopath. Works perfectly.

What I would like to have happen is when one is done filling out a form then they would hit submit or save or whatever and the data would automatically export to excel. The next time a form is filled out then the data would export and add on to the same excel spreadsheet and so on. I would end up with a excel spread sheet with all the data from as many forms that were filled out. The excel spreadsheet would live in the same directory as the Infopath form.

You would think this would be a simple task for Infopath but I cannot find anyway to do it. Is it really that difficult?

Kim

by asorondo

If somebody out there knows the answer, I will be VERY pleased.
Regards,
asorondo

This discussion is closed to new replies.