Test and Measurement Forum

Access Database

Post your VB and VBA discussions here

Access Database

Postby Damian » Wed Oct 18, 2006 9:54 pm

Hi

Is it possible to automatically import data from Picolog directly into a MS Access database?

If so, could someone please assist me with required VBA?
Damian
Active User
Active User
 
Posts: 5
Joined: Wed Oct 18, 2006 9:45 pm
Location: Cheshire

Postby Michael » Fri Oct 20, 2006 9:57 am

Hello,

YOu can do this with Access and VBA code. However, we cannot write this for you so we have supplied an Excel example with the software. Please check your .../Pico Full/ directory.

YOu will need to gather a single or block of samples and pass these into a new record for each reading. You will need to read up on creating a new record in VBA for Access.

Best regards,
Michael
Michael - Tech Support
Pico Technology
Web Support Forum
Michael
Zen Master
Zen Master
 
Posts: 656
Joined: Thu Jul 07, 2005 12:41 pm
Location: St Neots, Cambridgeshire


Return to VB and VBA (Excel, Access)

Who is online

Users browsing this forum: No registered users and 0 guests