....afaik, you can't import from SQL server, just from MS Access. Hope I’m wrong!

You are on the right track with the moniker other than that. In Access you can definitely import from a query. Just use geoImportAccessQuery in the import flags. Note, I have found that is fails with very long path names...or of course if you have a ! in the path somewhere.

I assume you know where the docs are, but just in case:

http://msdn.microsoft.com/library/en...asp?frame=true

Hope this helps.