array to database

[peanuts]

hello All,

I'm using the database connectivity toolkit to communicate with an Access Database. Works
pretty fine for reading out of the db - but now I have to write an array of strings
(5 colums, about 20 rows) to a table.
I create the table and define the rows using the 'create table.vi' and want to insert the
array into the table in a second step. But the 'insert.vi'seems not to do this job.

I'm sure there is a standard solution to this problem.

Simon

[Joel Andersen]

when putting arrays into a DB, you should define the column to be "image data". (I'm sorry but I forgot the word that the DB people use, it's not image data, but I think it is similar...). Since an image is a 2D array, that data type works perfect for arrays of data. It will let you insert the entire array into one cell. Sometimes strings and databases don't work well with each other (null strings, and termination chars). Look at the shipping example(s) that come with the toolkit to see various ways around this. I think that Access (in trying to appeal to everyone) is the worst at arrays of strings.