hexagon logo
Register Sign in
  • Replies 5 replies
  • Subscribers 222 subscribers
  • Views 104 views
  • Users 0 members are here
Options
Related

Access Database export problem

Imre Pem
Hello everybody,

This is my first post here. I currently want to integrate the measurement data into our company access database. I have created and registered an MDB database via the database wizard. Also, I inserted the STAT ON command into one of our programs to test out the feature. Sadly when the program reached this command, I received an error message like this: 

Error[-1] in [Transaction]
Data type mismatch in criteria
State:22005, Native: -3030, Origin:[Microsoft][ODBC Microsoft Access Driver]


What am I doing wrong?
Is it possible that the reason of this error message is that I use PC-DMIS in Hungarian, where the decimal separator is ","? I think the program should handle this (The CSV export uses "." as decimal separator) and I would rather not experiment with the language settings, because once it jammed my probe file.

Thank you in advance!
Parents
  • I had the opposite problem you had (I had dd/mm/yyyy formatting) in the output file from a data logger, I wound up writing a string hacking subroutine to change them. 

    Sub FixDate()
Dim i As Double, ii As Double, FF As String, MM As String, DD As String, YY As String

i = 1
Do
    i = i + 1
    FF = Cells(i, 1).Value
    YY = Right(FF, 4)
    FF = Left(FF, Len(FF - 5))
    For a = 1 To 3
        If Mid(FF, a, 1) = "/" Then
            DD = Left(FF, a - 1)
            MM = Right(FF, Len(FF) - a)
            Exit For
        End If
    Next a
    Cells(i, 2).Value = MM + "/" + DD + "/" + YY
Loop Until Cells(i + 1, 1).Value = ""





End Sub


    My dates were coming in like "21/7/2014", so the routine saves the last four of the string for the year, cuts off the last 5 (to get rid of the slash), then just finds the slashes to get the values and concatenates the pieces into a new date code. This routine should work for you with no changes.
Reply
  • I had the opposite problem you had (I had dd/mm/yyyy formatting) in the output file from a data logger, I wound up writing a string hacking subroutine to change them. 

    Sub FixDate()
Dim i As Double, ii As Double, FF As String, MM As String, DD As String, YY As String

i = 1
Do
    i = i + 1
    FF = Cells(i, 1).Value
    YY = Right(FF, 4)
    FF = Left(FF, Len(FF - 5))
    For a = 1 To 3
        If Mid(FF, a, 1) = "/" Then
            DD = Left(FF, a - 1)
            MM = Right(FF, Len(FF) - a)
            Exit For
        End If
    Next a
    Cells(i, 2).Value = MM + "/" + DD + "/" + YY
Loop Until Cells(i + 1, 1).Value = ""





End Sub


    My dates were coming in like "21/7/2014", so the routine saves the last four of the string for the year, cuts off the last 5 (to get rid of the slash), then just finds the slashes to get the values and concatenates the pieces into a new date code. This routine should work for you with no changes.
Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement