writing data to a table in MS Access database

[jasowiii]

Hi,

I'm having difficulty getting my application to write my data to an Access database table.

The application will (when complete) make measurements, about once an hour, from a number of DUTs over a period of ~12hrs. One record contains (for now, this will likely change) 14 individual pieces of data that need to be written to the database. The data exists in a 2d string array, Tab delimited with a Carriage return EOL to separate each record.
The problem I’m having is in how to write the data into an existing MS Access database table.
The existing Access table is "different" than my data records (i.e. there are more columns for other parameters/data that I'm not using in my data records). So I need to write individual table entries separately.

I have Labview 7.1 and the Database Connectivity Toolset.

Anyone have any suggestions on what I can do to accomplish this?
Jim

[Brian_Beal]

You are going to want to put your data into a cluster. Make sure that you have a one-one relationship with the columns in the database. The data type needs to be the same, and if you are not using some columns, you should write constants to them anyways.