AndSoft is a software production company specialized in the development of advanced software tools. We develop Supply Chain Management solutions in the transport-logistic market delivering complete ERP solutions for the final customers.

Description: The back-end of the ASP program is done in Microsoft Access. The Access database has 1 table which contains the job information. The administrator may add, delete, or edit the information through the Access database, or go to an administrator form on a web page to do the same. If you have a large amount of entries already established, these records can be imported into the jobs table by using Microsoft's Access import utilities. The Job Database consists of 5 ASP files (admin, index, insert, results, update), sample database (jobs.mdb), and sample images. We also send a detailed help file that shows you how to setup the program on your web site. For your convenience, all these files have been placed into 1 zip file.

No dll installation required: VBSdb is an open source VBScript object, compatible with ASP 2.0 and ASP 3.0. It works with both PWS, IIS 4.0 and IIS 5.0
Database independent: VBSdb supports ADO 2.x enabled datasources (Microsoft Access, SQL Server, FoxPro, Oracle, MySql and others)
Easy to use: Display your database queries with as little as 5 lines of code!
Four view modes: a Grid mode, a Form view and any combination of the two, allowing the user to browse a small number of key fields in Grid mode, while displaying current record complete details in Form mode
Advanced search screen: the user will be able to apply virtually any filter condition to select a record subset
Three edit modes: screens for adding a new record, for updating or deleting an existing one. Just 3 additional lines of code are required!
Style Sheets: Cascading Style Sheets (CSS) are fully supported
Advanced cell formatting: transforms field values to custom HTML. Trivial to display images from your database
Grid templates: fully customize your data grid layouts, writing simple HTML with special VBSdb tags to represent field values
Tables/Subtables: in a single page, you can easily place a main table and as many subtables as you like. Cascading subtables are supported!
Much more: order by columns with a click, client side input validation, advanced input controls for memo fields, localization support,

Generate code for any select statement. The following code wizard can generate code for any select statement. It generates code from the database connection to retrieving the values of your fields in variables.

For more information see Microsoft's Knowledge Base Article: HOWTO: Query and Update Excel Data Using ADO From ASP. If you're doing this as a method to get data to the users in Excel file format, please consider using this method instead: HOWTO: Use ASP to Query and Display Database Data in Excel. It's much easier on the server as it avoids using Excel altogether.