Does anyone know how Access figures out what data type to use when linking a table with excel. I am trying to link an Excel spreadsheet with an Access table and I have several data types in the Spreadsheet. I wouldl like to change the data type to text in the database but it will not let me change a linked table. I was wondering it I could somehow fool Access into making a column text