Reading data from an MS Access Database

Share your scripts written for the Script Device in this forum.
Post Reply
ScottBot
Site Admin
Posts: 2790
Joined: Thu Feb 13, 2003 6:46 pm
Location: Georgia (USA)
Contact:

Reading data from an MS Access Database

Post by ScottBot »

Here's a sample config to query data from an Access database. The sample import has a database with one table, Script Device, and VB script to display the data from the table.

It's very simple in what it does, but it will hopefully be helpful as a starting point to modify to meet any specific database needs.

To use the import, just drop the HBX file onto HouseBot and restart.
Attachments
MSAccessSample.hbx
MS Access Database Sample Import
(13.65 KiB) Downloaded 932 times
Scott
bjlamarca
Member
Posts: 83
Joined: Wed Apr 13, 2005 1:09 am
Location: White Plains, NY

Post by bjlamarca »

This is a sample script that adds a record to the Access Database, and then modifies an existing record. Install Scott's Access import first, than copy this script to the script folder and create a script device.
Attachments
InsertUpdateDBQuery.zip
(495 Bytes) Downloaded 894 times
Post Reply