Spreadsheet: how can I store test results from different tests in the same central spreadsheet?

[CBes]

I am looking to gather test data using LabVIEW. I then want to store all the data in the same spreadsheet, a kind of central data base. I know how to store single test data in a spreadsheet but I can I get the software to write new data in the same file without over writing the old data?

[mikeporter]

My first recommendation is that if you need a database--use a database not a spreadsheet. A DBMS isn't that hard to use and could pay big dividends in the future.In any case, to answer your question directly, it sounds like you are writing tab-delimited data to a text file that you will then open with a spreadsheet program. On the file write vi is a boolean input that specifies whether the new data should be appended or overwrite the existing data (the default is to overwrite). Mike...

[CBes]

Can I write to a file stored remotely on a network server, like a MS Access file?

[mikeporter]

Assuming an ADO interface, yes. All you have to do is setup a DSN that points to the right file...

Mike...

[chutla]

I agree the database method is the best. However, if that's not feasable, why not format your data so that each source shows up in a different column. It will require a couple of transpositions, but it's fairly easy.

Eric

[CBes]

I'm new to LabVIEW, so please forgive me. Is this possible without the database connectivity toolset? What is a transposition?

C

PS thanks for the help!

[mikeporter]

Yes, you can access databases without the connectivity toolkit. Search online for the "LabSQL" toolkit. It's free an is an excellent way to tie into a database. It even comes with a demo that used Access. In terms of your other question, transposition can be thought of as logically flipping a 2D array such that row 0 becomes column 0, row 1 becomes column 1 and so on. Mike...