Good morning all,
I have been searching hi and low with no luck to find a solution. I see several people have asked in either Excel, Outlook, and/or Access however I don't see any solved or answers. Maybe I am just missing it.
Anyways, here is my issue, I received three Excel (2003) email attachments once a month. What i would love to do is select a button in Outlook and have it load that data directly into my Access database. The headers will always be the same and the starting line (row to start taking the data) would always be let us say row 6, column a.
I have uploaded an attachment if needed, i will have to take some time though to get the personal data out of there because it has to be with employee hours and pay rates for an entire month. That is why there is three emails because it has so much data, and no I cannot access the data directly from the venodr (already asked-they said no...).
Any ideas? SUggestions on how to tackle this?
Thanks in advance for your assistance :-) Have a great day!!
Bookmarks