Pick data from MS Access 2003 and transport into web fields

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
TS
Newbie
Posts: 4
Joined: Fri Feb 05, 2010 7:17 am

Pick data from MS Access 2003 and transport into web fields

Post by TS » Mon May 24, 2010 8:47 pm

Does by any chance anybody have a sample script, which picks data from e.g. northwind.mdb/table1/line 15/field 2 to go into a web formular? Followed by further field values out of that line?

The use is meant for web sites (swap books, cd`s etc.), which not necessarily offer an upload format, but also would not mind, if an automation routine would deliver several sets of data. Any comment appreciated.

adroege
Automation Wizard
Posts: 438
Joined: Tue Dec 07, 2004 7:39 pm

Post by adroege » Mon May 24, 2010 8:53 pm

Use DBQuery and write an appropriate SQL select statement to retrieve the data you wish.

Example:

Select LastName from Customers where ID = 27

Post Reply
cron
Sign up to our newsletter for free automation tips, tricks & discounts