John Baird
Coatesville, Pennsylvanie, États-Unis
Information générale
Catégorie:
Bases de données
Versions des environnements
Hi Bonnie:
I've done a lot of importing with excel into datasets and the problem is with the implicit conversions to types in the dataset. For example, excel stores the date as the number of days from 1/1/1980 so it doesn't convert cleanly and can cause errors. Our import class was a mess to program for all the variability in the excel import.
>If you already know what the structure of the DataSet will be, start out with an .xsd already pre-defined with the datatypes, add the .xsd to your Solution and VS will generate a Typed DataSet for you. Then import your Excel into that Typed DataSet that was generated from the .xsd.
>
>I'm assuming this will work, but I haven't messed with importing Excel data.
>
>~~Bonnie
>
>
>>I am importing an Excel sheet into a dataset. So, of course, everything is now in character type. How can I update the dataset to specify that some columns are not integer and types like that?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement