Hi,
I am looking at using access (using VBA) to recieve a text file from a data logger though the serial port.
In the past I have created a program using MSCOMM to recieve data from a bar code scanner, but the amount of data was small and im unsure how it would cope with a large amount of data.
I basically used a timer that checked the buffer, if it wasn't empty then it recieved the data into a function that used the data. But how big is the buffer etc?
The code is used was:-
If mscomm1.InBuffe rCount >= 1 Then
wait
found (mscomm1.Input)
End If
Anybody got any ideas?
Thanks
Ben
I am looking at using access (using VBA) to recieve a text file from a data logger though the serial port.
In the past I have created a program using MSCOMM to recieve data from a bar code scanner, but the amount of data was small and im unsure how it would cope with a large amount of data.
I basically used a timer that checked the buffer, if it wasn't empty then it recieved the data into a function that used the data. But how big is the buffer etc?
The code is used was:-
If mscomm1.InBuffe rCount >= 1 Then
wait
found (mscomm1.Input)
End If
Anybody got any ideas?
Thanks
Ben
Comment