How can I Write a sine wave in an Access-file?

[happy-student]

I measure a sine wave in LabView 6i. How can I write the datas automatically to an Acces-file, at the same time?
In my program, I managed it with Execute SQL.vi, I change a number in a SQL statement(String) -> after this I push start and then it writes the statement in the Access-file.
The problem is, it writes only one data per measurement in the file. How can I write all datas in the Access-file and measure the wave at the same time?
Thanks for help!

[David Duffey]

On the waveform palette, you will find a "to components" vi that you can break out the array of the waveform. You can then, using a for loop write all of the values from the waveform.

Better yet, there are examples in the database toolkit manual on pages 3-13 to 3-15 that deal with reading arrays (and even has a waveform example).

Good luck!