I'm pretty sure I had it working, but maybe with a two part name ie.
LinkedServerName..TableName
However, when I went to look yesterday afternoon I had removed all of the mysql Linked Servers I was using for the project. I'll try to make some time today to look into it again. Sorry for not having the answer on the top of my head.
Thanks,
jim