Thanks Praneeth, looks like what your script builds & what I've got going produce pretty much the same output (once I comment out the few extra modules you've got that I don't). 1) I notice you're using shutil to just copy the applications directory rather than passing the correct tuples to data_files - that's probably an easier approach. 2) The data_files declaration you do have is missing splashlogo.gif, so the TK gui will not work. 3) You're not including routes.example.py, router.example.py or options_std.py probably not a major issue. 4) You're also including a bunch of API-MS-WIN-CORE-*.dll files which probably shouldn't be distributed with the app. Perhaps some extra shutil calls at the end to remove them?
Relating back to my original reason for starting this task - it looks like you don't need to do anything special to get pyodbc included - as long as you've got it installed it seems to get included in the binary distribution.