Getting EXCEL data INTO InfoPath form

[PapaBear]

Is there a way to import a data record FROM EXCEL into an InfoPath form?
Exporting is easy, the other way around is really important to us.

Help!

 

[PapaBear]

I'm talking about filling a form. I've developed a form to capture data from
customer interviews. I've 200+ records in EXCEL that have been captured
manually and entered into excel from a WORD form. What I'd like to do is
import the 200+ excel records into 200+ InfoPath forms so I can manage them
electronically instead of as individual documents.

Thanks.

 

[PapaBear]

so, how would one go about getting more help on this? WE have 200+ excel
records that would really be much better if we could get them into InfoPath.
What about converting to XML ... or does EXCEL support web services?

 

[Matthew Blain \(Serriform\)]

Are you using Excel 2003? Look into it's XML export functionality, it can
save as an XML file. (May need the Enterprise edition.)
Alteratively, you could write a VBA macro to go through the file, or save as
CSV/TSV and write a small program to create one (or many) XML file(s).

--Matthew Blain
http://tips.serriform.com/