Getting another program to access MySQL database??

[mattmc97]

I just started working with MySQL today.

I have a list of 8 rows by 11 columns that I exported from Excel into MySQL to populate my Database and that all made it through.

I am now trying to create a label with a label making program that will connect to a database. I have installed the ODBC 3.51 driver and tested the link and it finds the file.

When I try to open the database file from the label making program it says "Error Reading Record Fields", I click on details and it says "ODBC driver does not support dynasets."

I have no idea what a dynaset is or why it is an error???
Is there a way around this?

I can save the excel file as a DBaseIII .dbf file and it works but I wanted to be able to use a database for better tracking of information.

thanks in advance.

mattmc

[Spookster]

Is there a reason you picked mySQL for this instead of MS Access?

[mattmc97]

$$$$

Yes there is.

Trying to see if I could do it without buying Access for work.

mattmc

[whackaxe]

i use sqlyog from www.webyog.com i don't know if this is what you want but its what i think you mean