new datasource produce no tables



I have a new data source. I can access the data using SQLyog, but when I go
to Excel (2007) and choose a new data connection ... I use "from data
connection wizard" I can pull data, but can write the query to be anything
but 'select all'...
This does pull the entire table of data.

When I try with the data connection of 'from microsoft query" it tells me
all my tables are empty and i'm not sure where to go from there.

Maybe you can use microsoft query to write queries from a MYSql database? I
just need a point in the right direction.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question