LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

array of data to MS ACCESS

STOP posting the exact same question over and over again. As noted above, your code is nonsense and as noted In the previous post, you already have a solution and code that actually does make sense.
0 Kudos
Message 11 of 13
(1,129 Views)

@KartikPatel wrote:

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



Hi

 

I have found some of example codes related to database in NI Example.

 C:\Program Files\National Instruments\LabVIEW 2014\examples\database

 

Please gothrough it.

 

Thanks & Regards

Varaprasath M
Certified LabVIEW Architect
Certified TestStand Architect
0 Kudos
Message 12 of 13
(1,127 Views)

I think that:

  1. you can't have a period in a column name - change "Shot No." to "Shot No"
  2. you need brackets around the table name because there's a space there - change "Table 1" to "[Table 1]"

I was unable to reproduce your error.  I made an Access database with one table (Table 1) that had two columns (Shot No as Number and Time Stamp as Text).  I used a connection string instead of a UDL file (www.connectionstrings.com) and I'm able to write 100 records (with all the same data) each time I execute the VI.

 

Like the others have said, your code is nonsense.  What are you trying to do?

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 13 of 13
(1,098 Views)