Logger data into a access database

T

Toprunner

Hi!
I would like to use a dataaquisition device to send data into a access
database. Every read can be a scan of 10 voltage readins for example every 30
seconds... and the database should write a new row for each scan and also add
time to the row... IS this possible ?? I can connect the "logger" to Excel
and view readings there ,,,, but not make new rows.
 
G

Gregory Paret

Toprunner said:
I would like to use a dataaquisition device to send data into a access
database. Every read can be a scan of 10 voltage readins for example every 30
seconds... and the database should write a new row for each scan and also add
time to the row... IS this possible ?? I can connect the "logger" to Excel
and view readings there ,,,, but not make new rows.

I'm going to go out on a limb and say "Yes," if you can get the logger data
into Excel you can probably get it into Access, but you haven't given us much
to work with. Can you give us any more details as to how the logger is
"connected" to Excel (and perhaps why you can't use the same technique to
"connect" it to Access)? What do you mean by "not make new rows?" Knowing
which versions of Excel and Access you are using might be significant too. If
you could mention the brand/model of device someone with specific experience
may be better able to reply.

-Greg.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top