Hi:
If you followed the steps in the blog post and things work; but then you try the generated code and things don't work, you might want to open a track with Tech Support. It was my understanding that the blog post recommended using SAS/Access to ODBC to get to a Microsoft Access database file. But, does the EG generated code, actually reference DBMS=ACCESS or DBMS=ACCESSCS??? Just like this note shows the use of ExcelCS, you may have to use ACCESSCS instead of the "plain" Access driver???
http://support.sas.com/kb/37/479.html
That would actually be something you could find out from Tech Support -- as your operating system version, your Office version -and- your various servers might come into play in addition to your EG version.
You might also want to post this question in the Enterprise Guide forum, where more EG folks and the author of that original blog all hang out.
cynthia