Hi The ###### are only in excel. I checked the opened coloum and fixed any null values, still same error. thanks for the help i am going to start on it again tomorrow.