Hi,

I'm hoping someone out there has the answer to this question:

How does one convert a table column's data type from INT to CHAR/VARCHAR?

Background: I'm trialing some ID card software and it uses Access as its backend. It has ODBC capability and I'm able to connect to my website's MySQL db alright and even import a number of columns in my table (DATE, other VARCHAR columns). However, whenever I try to import the column that's INT (a two or three digit number), I get a type mismatch (on the ID card end I've chosen every predefined option they offer to no avail) and can't get any further.

If I can cast/convert the INT to VARCHAR I think I can get around the ID card software's limited functionality.

Can anyone help?

Thanks kindly,

-creativedynamo

did you ever get a response to your question?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.