BetaArchive Logo
Navigation Home Screenshots Image Uploader Server Info FTP Servers Wiki Forum RSS Feed Rules Please Donate
UP: 4d, 11h, 59m | CPU: 36% | MEM: 2960MB of 8095MB used
{The community for beta collectors}

Forum rules


Any off topic discussions should go in this forum. Post count is not increased by posting here.
FTP Access status is required to post in this forum. Find out how to get it


Post new topic Reply to topic  [ 2 posts ] 
Author Message
 PostPost subject: Data in?        Posted: Fri Feb 02, 2007 7:02 am 
Reply with quote
FTP Access
Offline

Joined
Wed Oct 04, 2006 2:06 am

Posts
258
A friend of mine sent me this, what should he do?
>OK, here is today's problem.

I don't know if you got to see it at the star's club meeting, but I
have this xrite.com model 938 spectrophotometer.
I called the factory and they told me the key code to get it out of
the loop and it works fine now.
and what it what it does, is take a sample reading , then transmits
62 lines of data , some lines blank and all lines contain alpha and
numeric data.
It comes out as rs232, set at 9600, 8,n,1
I put it into a keyspan rs232 to usb adaptor and plug it into my
notebook. it shows up on COM5:

I need to take all the data, add the date and time to it along with a
fixed reference number (scanner serial number) and than a record
number to IDing each set of data and then store it.

I then need to be able to get to the data by ID number.

How would you do it?
I am thinking of Access, but I don't know how to write the code to
suck in the serial data.
I am also trying wedge software.


Top  Profile
 PostPost subject:        Posted: Sat Feb 03, 2007 2:26 am 
Reply with quote
Donator
Offline

Joined
Sat Aug 19, 2006 1:25 am

Posts
590

Location
Israel
If this guy wants to use Access, using VB6 to decode the serial data and put it in a database would be pretty trivial (even for me, with my very poor Access experience). The Comm control could easily read the data from the serial port (through a USB adapter or not), then ADODC can add it into an Access database.


Top  Profile
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 




Who is online

Users browsing this forum: No registered users and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Jump to:  

All views expressed in these forums are those of the author and do not necessarily represent the views of the BetaArchive site owner.

Powered by phpBB® Forum Software © phpBB Group

Copyright © 2006-2018

 

Sitemap | XML | RSS