I am trying to import a lot of data in CSV format into Power Pivots Data Model. One of the fields is predominantly numeric, but there are instances where the data is alpha-numeric. When importing the data Power Pivot enforces a data type on the column of numeric, which means it then fails when it finds a row where the field is alpha-numeric.
How can I force the data type for a column so I do not lose data in these fields?
(see the same thing happening if I use 'Get Data' in Excel.
Thanks
I have made some progress and think that this can be resolved using a schema.ini file, so I have written a file like this;
[container.csv]
Format=Delimited(~)
Col9="Container Id" TEXT
Column 9 has a header of "Container Id" and is the one I want to import as TEXT. The above does not seem to work (though the delimiter part is working and PowerPivot identifies the Schema file). I think the syntax must be wrong, but I cannot see why or where.
Bookmarks