Importing "Hyperlink" fields from Acces

[Anon]

Hi,

I am trying to import data from ms-access'97 to mysql. The problem is i have a field with the data type as hyperlink. Whenever i import, the result is ok, except for the hyperlink field. That field alone come with all ##www.xyz.com### and things like that. How do i avoid this from happeneing ?

Karthik.

[Anon]

Change the access database design and change the column data type to text and then import. That should solve your problem.

[Anon]

Or, if you can't (or don't want to) change the database design, it should work to just strip off the # characters before storing the data, e.g.:

$string = ereg_replace( '^{##(*)##','\1',} $string);