I receive an excel file about once a month where I need to extract only portions of the data and place in existing records of a table. I have no desire or need to keep the file so would like to open the file from Outlook and then retrieve the data from within access without having to save the file to a folder and then open it using VBA within Access. I cannot figure out how to create the instantiation to the file since it's already open. Would appreciate any help I get.
Thanks TC
Thanks TC