>Have you tried formatting the column in excel as character or numeric? If you have an alignment problem, seems to me that you are using general. This causes problems with imports.
>
>We worked on our imports for months to get the vagaries of excel worked out so that they would reliably import. You can't expect to simply import from excel and have everything perfect. We ended up developing an oledb solution and a direct solution where we used automation to return an array of cell values, which we then inserted into a dataset performing the datatype conversions on the fly as we did so.

Thanks