Hi, let me try and explain my problem...
I have a program writen in VBA that at some point creates a new (temporary) BD table inside vba by importing a excel sheet...

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Participants_temp", path, True, "Participants!"

This excel sheet contains spanish characters like the chr(241) =

All is still fine, a new table is created and the character in question is present in the table.

Now, when trying to work with this table, eg exporting it to mySQL DB, this character (chr(241)) is turned into a question mark (?).

So my question is what I need to do to convert it or keep it in it's origional state...

ps. this only happens with the character 241 = , all the other character work fine even after the export...

ps.ps. working with Ms-office 2000..

Thanks for your time!!