Is this a one time process or does this import need to be done on a regular basis and automatically?
One way would be to save the excel as XML and then recieve the xml via a data connection and then map the data from Excel(XML) to your form XML. The fields would contain the information and only certain fields would show on a given view.
Otherwise you should have SQL Express and import Excel to a SQL table. This can be completely automated with a DTS script or the excel sheet can pull its data directly from SQL and it can be the central storage location. Then you form can interact with the data from SQL. You may want to look at the Database Accelerator if you choose to store your data in SQL. Qdabra Database Accelerator Suite Version 2.1.2815 - Developer