04-04-2011 07:10 PM
I used almost of my time today to figure out how to store data into database (Microsoft Access 2007). Finally, I got the data stored as long binary data format, however, I would like to store as some form that I can see directly when open the database (using Micosoft Access) and I stucked with this at least 3-4 hours (online searching, example) and I still did not figure out yet. I would like to get help.
I sampled the data from DAQ with 8 analog inputs, the output data from DAQmx is array type, I try to convert it input other data type but I either got long binary data format into database or an error.
04-04-2011 09:06 PM
I successfully use these SQL tools to write to an Access DB.
http://jeffreytravis.com/lost/labsql.html
In Windows XP you have to use ODBC (in Administrative tools in your control panel) to specify the database location.
Let me know if you need any more information. I can send block diagram screenshots of how I'm using it if it will help.
Eric