labview with access database

[314159ym]

Hi everyone:

I am using labview opc server collection data from 5 plcs then store into access then someone can query these data later.

Problem is i can not combine 5 plc`s data into one table,now 5 plc`s data in 5 different data table and all the data collecte are in 5 tables in access database

Does someone now how to put all the data in one table and all the queried data are in one table.

[bseguin]

From What I see, you need to cleanup your code.

Second, please send you VI... the picture is not enough.

Benoit

[carmen9 · Accepted solution]

This might help:

https://forums.ni.com/t5/Example-Programs/Concatenating-Multiple-Text-Files-in-a-Spreadsheet-Using-L...

https://forums.ni.com/t5/LabVIEW/Combining-data-and-table-display/td-p/3806452

[314159ym]

Here is the  VI

[314159ym]

it works now thanks

[GerdW · Accepted solution]

Hi pi number,

it works now thanks

How did you solve your problem?

Maybe that could help other people stumbling over your thread! (That's how this forum actually works…)

On your VI:

- Please use only English chars (aka plain ASCII) for filenames as using asian UniCode chars will give problems for most users.

- Please remove those Rube-Goldbergs in your code! Why do you need to compare boolean values with TRUE?

- Why do you need shift registers to handle all those buttons?

- Why do you need to create events using that additional while loop and property nodes? Why not react on button value change events directly?

- Why is there a wait function in the event loop? Why don't you use the Timeout event instead, even though you have that event case? (In your VI you don't need both the wait function nor the TimeOut event!)

- Use AutoCleanup, set string constants to "size of text"

- Never use that "Exit" function in your code: its like using a tree to stop your car! End your VI in a graceful way instead…

[314159ym]

I used the "insert into new_table    select (a.1,a.2....  b.1,b.2......)   from tableA,tableB where A.ID=B.ID"

After this then i select the data from new table

[Yamaeda]

It looks like the Where is badly formatted with the dates written merged with the And. "Where  [field] between #2018/1/1#and#2018/12/31" looks strange, i'd assume the spaces around "and" are important so it should be "Where  [field] #2018/1/1# and #2018/12/31#" 

/Y