>Rick,
>
>>>The first one's easy... Where can I find a summary of information on VB data types?<
>
>You probably mean OleDb data types. For OleDb, simply look up "OleDbType enumeration" in the help.
>
>>>The second one is easy too... but it's more wordy...
>
>Nope, not quite so easy. <g> I'm not sure which Access data types map to OleDb data types (since I've never used Access). As a SWAG, I'm guessing that maybe your integer type might be wrong, like maybe you need OleDbType.BigInt or OleDbType.SmallInt instead of OleDbType.Integer. One way to tell for sure might be to write your DataSet out to XML and see how the various columns get represented. This *may* tell you which data types you're using.
>
>~~Bonnie
Bonnie,
Thank you. I think you're right on question #1
On #2, it sounds like a good approach...
Are you referring to converting the access table to XML,
or my apps DataSet that I'm trying to do the Insert with,
or both?
Either way, I've not done that before....
so the question becomes... how do I do that?
Rick
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