Hi Trevor,
I have had similar import errors/problems. My fix was to "prep" the
Excel sheet being imported. That means that I had to manually convert
each column in the Excel worksheet from General to the respective
datatype, text values like Name are text, numeric values are numeric,
date values are dateTime - highlight either the entire column(s) or only
highlight the column to the end of the text and right-click and format
to DateTime.
In worse case scenarios - if prep above didn't get it - I had to
programatically rewrite the data in Excel in each column because the csv
file either contained ' (single quote or apostrophe before each cell
value) or the data contained some null pointer value at the end of the
value.. So I had to use an Excel range object and loop through the
range and parse out the ' symbols or just copy each value and cast it as
its corresponding data type - that is worst case scenario.
Just by modifying the data types of each column should get it.
Rich
*** Sent via Developersdex
http://www.developersdex.com ***