Re: Get Data Type

PMFJI,

To the extent that it's not insoluble in the ways already pointed out in
this thread, it sounds like a pattern matching problem - but ISTM the
way to approach might be to start by transposing the columns in the
input file into rows.

This would give a file with one record for each field in the original,
each record consisting of a delimited string containing all the values
in the corresponding field in the original. Each of these strings could
then be tested against a series of regular expressions - each aimed at
_excluding_ a given field type.





On Tue, 21 Mar 2006 11:22:44 GMT, "IanOxon via AccessMonster.com"
<u18965@uwe> wrote:


Hi All,

I'm looking for a way to evaluate a string and return a possible data type in
.NET, Classic VB, or VBScript (I'm not fussed which). For example:

String Passed ADO DataTypeEnum DAO DataTypeEnum

"12/12/2004" adDate dbDate
"True" adBoolean dbBoolean
"G12" adVarChar dbText

Are there are existing functions/methods that handle this?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

.

Relevant Pages

  • Re: Entering data in a screen programatically
    ... so now you know that Access was performing a string comparision. ... > Allen Browne - Microsoft MVP. ... >> The form was set up with two combo boxes, cboFiscalMonth, ... What field type? ...
    (microsoft.public.access.formscoding)
  • Re: Long Integer truncates 0 at beginning of number
    ... a human in that format. ... If you want to change it to a string: ... characters, then it is likely NOT a number (something you'd ... Is there anything I can do to keep the field type long? ...
    (microsoft.public.access.gettingstarted)
  • Re: SQL Statment
    ... > Dim strWhere As String, strSQL As String ... > The case contains redundant code, but each field type has to be taken into ...
    (microsoft.public.vb.general.discussion)
  • get multivalued data from a Recordset
    ... how can i deal with multivalued fields (field type = adVariant) ... i need to get data from a field with type adVariant and convert it to string ...
    (microsoft.public.data.ado)
  • Get Data Type
    ... I'm looking for a way to evaluate a string and return a possible data type in ... ..NET, Classic VB, or VBScript. ... String Passed ADO DataTypeEnum DAO DataTypeEnum ...
    (microsoft.public.access.modulesdaovba)