InfoPath Dev

thanks for the suggestions barmatt80. i solved the problem using an unecessarily complicated work-around. I have a macro in an access dbase that runs saved imports and pulls in the excel files to local access tables. That macro is called by a vba onsave event in each of the excel docs, so when users save the excel docs they automatically ...

I'm having a problem consuming data from excel. I have several large excel spreadsheets that I want to pull data from to populate fields in an InfoPath form. Currently I have an Access dbase setup with linked tables to the excel sheets (located on my LAN) and then I use an ODBC DSN data connection to get Infopath to talk to Access ...