Dear Eli
You can not import Access data directly into an InfoPath form. Of course,
you can do it programmatically but using rules (which seems to be your
requirement) there is no easy option. Use following steps to import Access
data (without writing code):
1. Export Access data to a SharePoint list. Go to 'External Data' in Access
and select 'SharePoint List' from the 'Export' section.
2. Create a new data connection in InfoPath and select following options:
a. Create a new connection > Receive data
b. SharePoint library or list
c. Enter the list's path where you exported the Access data
d. Select the field that you want to show in InfoPath.
e. Check 'Store a copy of the data in the form template'.
f. Add a name for the data connection
Populate the text box with Access data:
1. Right click the text box and click the button (fx) in the default value
section.
2. Click 'Insert field or group'.
3. Select secondary data source from the 'Data source' drop down.
4. Expand all nodes until you see field names. Select the field that you
want to retrieve value from.
5. Click OK twice and that's it!
Your text box will now show value retrieved from the Access DB.
Hope this helps!
SSA
MOSS MVP
