LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

array of data to MS ACCESS

Hi,

 

I am trying to Insert 52 fields of data In MS Access. One error display repetitive as attached in Image.please help to resolve this.

Download All
0 Kudos
Message 1 of 13
(4,921 Views)

It's tough to say without seeing the data in the "columns" control.

Jim
You're entirely bonkers. But I'll tell you a secret. All the best people are. ~ Alice
For he does not know what will happen; So who can tell him when it will occur? Eccl. 8:7

0 Kudos
Message 2 of 13
(4,919 Views)

hi,

 

PFA of BD and FP of Vi.

0 Kudos
Message 3 of 13
(4,907 Views)
From the image, your code does not make any sense. The for loop repeats 52 times with the exact same data. Are you wanting 52 rows with the DBL array constants in them?
0 Kudos
Message 4 of 13
(4,881 Views)

That vi doesn't help; the "columns" control is an empty array.  You need to save the data as the control's default value.

Jim
You're entirely bonkers. But I'll tell you a secret. All the best people are. ~ Alice
For he does not know what will happen; So who can tell him when it will occur? Eccl. 8:7

0 Kudos
Message 5 of 13
(4,847 Views)

A couple of things:

 

- Replace the Database TimeStamp with a Get Date/Time in Seconds and use the Format DateTime String with this: %Y-%m-%d %H:%M:%S

- I don't think you can place an array into a field like you are attempting with that last bundle element. I've never tried it but I believe you need to break that down into the elements that are within that array.

 

What is your overall goal here?

0 Kudos
Message 6 of 13
(4,826 Views)

Hi,

 

I  Want to add 52 fields in MS Access via attached Vi.but this error occurs repetitively.so, I wired N-terminal.

Please help in this matter.

0 Kudos
Message 7 of 13
(4,773 Views)
Your code still does not make any sense. Your dbl array is empty. You need to write one row at a time. The data does not change. You need to create an array of rows, not a single one with an array in the cluster.

Another reason to avoid the toolkit. It hides so much and allows for really silly code.
Message 8 of 13
(4,763 Views)
0 Kudos
Message 9 of 13
(4,725 Views)

Please tell me how can i insert 52 Fields in MS Access database and respective records to each  Fields. this error occurs repetively. 

Download All
0 Kudos
Message 10 of 13
(4,699 Views)