How to insert data into MS Access defined by data type

[222]

This is my example of vi which is being tested. You should create a blank .mdb and a udl file to link to the database file that you have created and also delete the subvi (1).... (I think that shouldn't be a problem for you all)

[becktho]

So when I open you vi, I see that the format string looks like this:

%d-%b-%y

Mine looks like this:

%d/%m/%y %H:%M:%S

I think this depends on your local settings, but you definitely have to wire the data in the correct format. I'd suggest you to just insert sample data in the database directly. Then use labview to retrieve this data and you will see how the string looks like. You will then have to wire the same format when writing data. That's the way I would do it...

[222]

Ok.. will try it out tomorrow morning.. the sky is getting dark here.... THANKS