Connecting with Excel

[umba-sr]

Hi,

I know that Infopath works only with Access, but is there any possible way
to connect it with Excel, cause I am kind of used to it.
Also, wheather with Excel or Access, is there a way to, when I connect all
the data to the form, to just enter a number, and to have rest of the form
filled out according to the table that I previously connected it to?
For example, I have employees' names, addresses, numbers and etc. I want to
enter number of employee and have all remaining fixed data entered
automatically.

Thanks for all kinds of help. More answers to my question, better.

 

[Chris]

Hi,

I know that Infopath works only with Access, but is there any possible way
to connect it with Excel, cause I am kind of used to it.

If you save the Excel sheet as xml then you will be able to create a
normal data connection in infopath.

Also, wheather with Excel or Access, is there a way to, when I connect all
the data to the form, to just enter a number, and to have rest of the form
filled out according to the table that I previously connected it to?
For example, I have employees' names, addresses, numbers and etc. I want to
enter number of employee and have all remaining fixed data entered
automatically.

There are loads of examples of this on the web. Try:
http://www.infopathdev.com/howto/tutorials/default.aspx?i=9111ef580f95479890fc18fb2c5bac85

Hope that helps.

Chris