ACCESS requests to MySQL

I'm migrating a base from ACCESS to MYSQL using ODBC.
My problem is that I have a field declared as an "int" in ACCESS but the filed also contains the "name" correspondin to that "id", via a request in ACCESS. When I transfer it to MYSQL, I get only the Id, my field type being an "int" here too. How do I get MySQL to show me the "name" data in the same field??
Thanx for any answers.

What program did you use to port. I have seen a script or program that worked well in past for us, but I can't remember the name of it. I think it was access2mysql.

I found it here for DL, its shareware:

http://www.tucows.com/preview/253162.html

that is for Win users, there was another script we used in Linux.

Can you clarify:



I don't understand what you mean.

Thanks,

Nao

ok, seems like I misunderstood the whole thing.Here is what.
In my ACCESS Db , a column of my table (A) gives a scroll list of names correspondin to the ids of another table (B).
But when I transfer my base to MySQL only the id number of the corresponding data from table B appears in the column of my table A. How do I display the name instead of the id liek in ACCESS?
I understand I might not be clear n maybe this is be a newbie question ...but I am new to this, thx

hello...?