OK got it... Create the DTSX pkg and save as a local file, create a Stored proc with the line

exec

Thanks for the confirmation of Best Practices...I am in the choir and at times lead the way, however nasty budgetary considerations have always hamstrung me and so I just solider...

I ran this by our Domain guys and they are not sure of the workability of this scenario. 
I figure the user name is 'NT SERVICE\SQLSERVERAGENT'.  It is a...

I am thinking it is all related and you (the forum) is helping me chip away at my issue, so I am thinking all one thread it is just that...

K, thanks for the guidance but still no joy.  I can create a DTS package that works, I can save it tot he File System or to SQL Server.  I...

Cool, thanks... I'll verify or make adjustments as per ur suggestions.

K, I had a look at SSDT and had a stroke...  So in place of that I recreated my DTS package and saved it within Sql Server.  It takes an...

Thanks for some direction.  Additional data... This will be an ongoing process and I'll be required to with several Excel files, some will required weekly processing, others daily and at...

Thanks for the responses... I am naturally lazy and was looking for the easy way out... just feed me 🙂  I don't want to fish  🙂 

I am using...

Hey thanks for the quick responses... yes direct from csv or Excel would be the preferred method, but I have searched but the methods described are a little to ......

MS Access and the Agent are on the same box.  The Access app runs an Autoexec which does some required stuff then closes the app and Access.  My desired next...