Importing Excel Errors, Odbc And Schema.ini

How can you overcome importing excel file errors? When the datatype is incorrectly determined it is because enough of the file has not been scanned. txt and csv files you can set

Solution 1:

If you are able to convert the file to csv, you will have an easier time importing it using the 'Suggest Types' feature which allows you to scan through x rows in your file and pick the most appropriate data type for each column.