I am trying to import a spread sheet in Access, I have a macro setup to transfer spread sheet. I have two problems, one is when I run the macro i get a message that the file is already open or i do not have permission. The file is not open and it is a personal pc? Next when I am able to run the macro on another pc one column does not import correctly - as text. The spread sheet is set up as text and the table i am importing it to is also setup as text. But when I import the date i only get the numeric data and not the text data?