I am looking to link some excel files in an Access DB.
I need to change the data type on import however. The excel file has a data type of number for a particular column and i need it to be text.
Access says i cant modify the properties. How can i get round this?