connecting labview to microsoft access 2003 or notepad

[mic_k86]

hi all, how to connected data collect in labview (in my case is temperature value, date and time) to microsoft access 2003 or notepad? which method easier?

[MikeS81]

Hi mic_k86,

please explain what you like to do. I´m not sure what you mean with connect to notepad. If you want to store data you can use the File I/O functions to read and write it.

Mike

[Mathan]

You can use system exec to write in notepad. That will be very easier

[Edit: Mike is always very fast.

Which version of LabVIEW are you using?]

Message Edited by mathan on 01-07-2009 03:17 AM

[gt3000]

Hello mic_k86,

LabVIEW can be used to write acquired data to both an Access Database and Text Files.  The LabVIEW Development System will include the VIs needed for writing arrays of data to files with extension of '.txt' and '.csv'.  These types of files can be natively opened by text editors, such as Windows Notepad. 

Connecting to a Microsoft Office Access Database may require the use of the Database Connectivity Toolkit.  Help files exist within the LabVIEW 'Help'->'Example Finder' and on the website.  For further help, please reply back with the version of LabVIEW you are using, and your Operating System, and I can recommend specific examples. 

Regards,

[mic_k86]

Hi all,

i am using labview 8.5. i have use the write to measurement file and i successfully save the temperature value. however, the data format save not as i preferred. i just can save the temperature value but cant save the date and time. i plan to have the lvm file like this:

9/1/2009   20:00:00   28.54

9/1/2009   20:00:01   28.65

9/1/2009   20:00:02   29.00

9/1/2009   20:00:03   27.23

9/1/2009   20:00:04   28.99

how to do this?

( i want to attach an image of my block diagram to this thread from my pc for clearer explanation about my problem but i dont know how to do it, anybody can help?)

i connected the temperature value from comparison palette to the write to measurement file's signal , my date and time is at get date/time string.

[DFGray]

LVM has a very rigid format so that it can be reliably read.  You can find this format here.  LVM asssumes an initial timestamp (saved in the header) and normally puts relative offsets from that in the X column of data. There is no option for a date column and time column.  Thus, you cannot do what you want to do with LVM.  However, it is fairly easy to do with the LabVIEW file I/O functions.  Check out the ASCII file I/O functions and let us know if you run into problems.