When using my importing file, the data from the excel file get imported but not the last column. I think the problem is that the excel file has a record in one of the field with almost 400 characters. I changed the format of this field to memo but still I have the issue. I realized that when I use my import macro and the excel file is open, the file get imported fine but if I try to imported when the excel file is close, the last column of the excel file does not get uploaded. Does anyone knows why it works when the excel file is open vs when it is closed?