Hi I am working with Visual Basic application on one of my data logging unit in which data speed is 1000 sample per second the data logging unit will run for one or two complete day. Which means for one day data amount will be 86400000 samples can easily be stored in below buffer. Or partially after 2-3 hr data can automatically save to selected drive.
How I can save data above data in excel format. Or which is the best way to store data. Below is my buffer in which data get store:
Dim DataSet(0 To 1000000000) As String
Public Sub OnRead(ByVal pHandle As Integer)
If StartLogging = 1 Then
Time(SamplePerSecond) = TimeValue / 1000
DataNo = DataNo + 1
DataSet(DataNo) &= TimeValue / 1000 & vbTab & (Int((CH1_RawADC - CH1_Tare) * CH1_CalibrationFactor) / CH1_DP)
If you need to save it so it can be read by Excel, I'd say at the end of the sampling period, write the dataset to a CSV (comma separated value) file.
A quick check of my Excel (Office 2010) shows a maximum row count of a little over 1,000,000.
Since you expect 86,000,000 samples, you will have to have 86 or more samples per row.