Hi,

I'm trying to import data from a mysqldatabase. The connection and import is working ok, untill I try to import a table with characters in de collum/fieldnames which access can't handle (. and ') Is there an option to change the fieldnames on import, (with caracters removed) so that i can import the data?

I can't change the table in the mysql database itself, because it has tot stay that way for other purposes.

Does anyone know if this is possible?

Thanks in advance