Import External Table, Access does not like Field Name

[lucour]

Hi,

I would like to link to an external data source (table) from MS Access 2003. I attempt to use the 'Import' feature to do this, and select 'ODBC Connection'. I am trying to connect to an application called 'Action Remedy'. I make the connection fine, but when Access attempts to import the table, it does not like one of the Action Remedy field names, and the Import aborts. The name is something like "Call Status-History.Closed.Time". Obviously, Access does not like this field name. And the chances of getting it changed (on the A/R backend are slim to none). Thus, my question: Is there away around this ?

Thanks !

 

[Ron_dK]

Can't you export the data from the Action Remedy dbase to an .asc or .txt format and then import it to Access. Or maybe even thru an excel sheet.
If you can, you'll be able to change the "Call status......" field description and get a proper import.