How to get an infopath form to update an excel spreadsheet?

%3CLINGO-SUB%20id%3D%22lingo-sub-862695%22%20slang%3D%22en-US%22%3EHow%20to%20get%20an%20infopath%20form%20to%20update%20an%20excel%20spreadsheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-862695%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20bunch%20of%20location%20data%20on%20my%20Excel%20Spreadsheet%20and%20I%20require%20this%20to%20be%20validated%20which%20I%20will%20be%20doing%20through%20an%20infopath%20form.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20infopath%20form%20should%20be%20able%20to%20retrieve%20data%20from%20the%20Excel%20Spreadsheet%20for%20others%20to%20view%20and%20validate.%20When%20they%20press%20submit%20this%20form%20should%20update%20the%20Excel%20Spreadsheet%2C%20adding%20in%20new%20rows%20if%20necessary.%20So%20the%20infopath%20form%20should%20be%20able%20to%20send%20and%20retrieve%20data%20from%20the%20excel%20doc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20would%20I%20go%20about%20this%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EDevin%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-862695%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Einfopath%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EResponsive%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hi,

 

I have a bunch of location data on my Excel Spreadsheet and I require this to be validated which I will be doing through an infopath form. 

 

The infopath form should be able to retrieve data from the Excel Spreadsheet for others to view and validate. When they press submit this form should update the Excel Spreadsheet, adding in new rows if necessary. So the infopath form should be able to send and retrieve data from the excel doc.

 

How would I go about this? 

 

Thanks,

Devin

 

0 Replies