https://communities.sas.com/t5/SAS-Enterprise-Guide/excel-import-in-EG-4-2/m-p/29730#M4071 Please work with SAS Technical Support on this issue. They might ask for a copy of your 4.1 project, 4.2 project, and a sample Excel file, if you can share those.<BR /> <BR /> Chris Mon, 08 Nov 2010 20:56:34 GMT ChrisHemedinger 2010-11-08T20:56:34Z https://communities.sas.com/t5/SAS-Enterprise-Guide/excel-import-in-EG-4-2/m-p/29729#M4070 i just updated to 4.2 and now most of my projects doesnt work anymore. This caused me a lot of trouble for the q3 reporting.<BR /> <BR /> the problem is the import of date columns from xls. In the previous EG version i had to use a specific read-in format (ANYDTDTE) and all worked fine with a DDMMYY-output format. Now it doesnt anymore.<BR /> I get a pop-up message from the new import that most of the coloumns have changed type (which they havent since the xls-file is excactly the same) and that is probably the problem.<BR /> <BR /> How can i get around this?<BR /> I installed the hotfix, but it doesnt seem to help much. Mon, 08 Nov 2010 08:20:37 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/excel-import-in-EG-4-2/m-p/29729#M4070 norway73 2010-11-08T08:20:37Z https://communities.sas.com/t5/SAS-Enterprise-Guide/excel-import-in-EG-4-2/m-p/29730#M4071 Please work with SAS Technical Support on this issue. They might ask for a copy of your 4.1 project, 4.2 project, and a sample Excel file, if you can share those.<BR /> <BR /> Chris Mon, 08 Nov 2010 20:56:34 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/excel-import-in-EG-4-2/m-p/29730#M4071 ChrisHemedinger 2010-11-08T20:56:34Z