Hi All, I have an Oracle function that uses 4 data elements. I have a file with these four elements that I want to ultimately pass through the function, however, I'm stuck at connecting to the database when using the function. This connection and query works: DBConnect>Provider=MSDASQL.1;Password=xx...

My apologies... I posted to the incorrect post

I want to be able to do a macro of redundant data entry. The place the data goes is the same, but the data isn’t the same. I would like to read items from an excel file and enter the information in specific areas, For example, I have a two column file with a list of ID and Program. I want to build a...