Results for "Category: Databases/ Data Access/ DAO/ ADO"

This is the code from a class module for exporting from any Jet database to any ISAM format out there. I think it neatly encapsulates the process, and uses properties and methods to make the process as easy as possible.

It allows you to import any .DBF file into an access database. You can choose the new table names, select individual fields, and create a new Access97 or 2000 database if one is not there already.

The program Creates a VB Class Module from a DTS Package on a SQL Server, with all events, and its own events(Progress, currentTask, etc) It creates a very compact script, so you can very large packages in a single routine. The Class Module "ClassDTSScript" is what is created when you get a package from the server and script it. Simply remove the example, and add one you have done to test it. The example execution asks you to navigate to the source and destination Access Databases, and uses the filepath to pass in an ADO style connection string for the source and destination connections. The parsing routine in the class module will work for SQL Server or ACCESS. I have not handled more complicated transformations such as Many to one column mappings and such, but Execute SQL and DATAPUMP Tasks work quite well. The Example "ClassDTSScript" module included was created from a package in SQL Server 7, and includes a couple of queries, two transformations, and running a stored procedure with a parameter, as well as demonstrating using the events that are called by the DTS Package object. Read the comments in the code carefully to better understand the uses.

Uses DTS (Data Transformation Services) from within VB

Demo for database access class automatically generated by CLASSter. Full source demonstrates calling stored procedures, executing parameterized SQLs, multiple recordsets, batch execution, transaction control, XML processing, error handling, etc.

An alternative method of reading an MS Excel Spreadsheet.

This VBA Automation demonstration assumes that Microsoft Excel 97 and Access 97 are installed. It hasn't been tested yet with Office 2000. My work required an Excel application that could generate charts based on information in Access. After searching PSC I came upon a great example by Joe Miquel which I've built upon. Once you've started the application all you will need to do is Click on the Excel Button on the Access Form. Feel free to expand and to innovate the code. Many thanks to PSC and to Joe Miguel for a great idea. Hope you like it.

A valuable tool in your programming toolkit. Use this routine for when an Access table goes bad. Often when this happens conventional INSERT or APPEND queries or cut/paste techniques don't work for backing up your table. This is a routine for copying data from one table to another table, field by field. As the information is processed, bad data fields are skipped over and logged in a log file. Only good data is deposited in the target table. **re-uploaded/Corrected II**

Updated: Dec 02 2001, Ver 2.5 updates are functionality to associate MS Access (.mdb) databases with Database viewer/editor, and to Maximaze the application. View/Edit data on databases that can be MS SQL-Server local/lan or remote on internet, or a MS Access database. Get Data by clicking databases/tables/columns/views/stored procedures or perform custom SQL queries. It shows ADO Programming and Some API. In this version I have fixed some bugs from previous releases and improved the functionality. Now you can view the "source" of all stored procedures and views in SQL-Server. Thanks to all who came with feedback/suggestions in previous versions of this application. The project is made with VB 6.0 Service Pack 5 and I used MDAC 2.5. Please help me grow as a programmer and come with feedback/suggestions.

This example will show you how to move items from datalist (which is connected to ADO control) to a listbox.

DataAccessDLL's SUCCESSOR - as a control. GREATLY simplifies accessing JET or SQL Server databases. No more Connection String, provider, data source, Persist Info etc. properties to fill in. Provides easy to follow instructions right inside the CTL with an 'INSTRUCTIONS' function.

** PLEASE VOTE FOR MY CODE - EVEN IF YOU DON'T LIKE IT ** GREATLY simplifies accessing JET or SQL Server databases. No more Connection String, provider, data source, Persist Info etc. properties to fill in. Provides easy to follow instructions right inside the DLL.

This code can be used as a template for creating master forms.

Creates a Microsoft Database (MDB) on the fly and adds tables dynamically in Visual Basic. The program needs a reference to Microsoft ADO Ext for DDL and Security.

THIS IS AN EXAMPLE OF HOW YOU CAN DO A SIMPLE TABLE WITH DATA, SO YOU CAN NOT USE THE FREEFILE() , YOU CAN MAKE MSFLEX GRID, TEXT BOX,COMBO BOX ETC WITH THIS CODE, AND IS SO EASY, TRY IT, PLEASE DONT FORGET TO VOTE FOR ME THANKS.....

ADO Helper 2.0 now includes example projects to demonstrate the working of ADO. This will help to directly use the codes in application. Example projects include: Demonstrates how to use Cross Tab, How to handle ADO Errors, ADO Find and Seek Methods, How to use ADO with Grid Controls, Use ADO with Data Report to create Simple Data Report, A complete ADO Unbound example to show, add, edit, save, delete with navigation with error handling, How to practically handle ADO transactions. These example programs will definitely help beginners and pros alike. With the passage of time, ADO Helper will become the complete source of ADO Help and Example programs at one place. Coming soon are topics such as: Data Consumers, Data Shaping, ADO MD to summarize data, Creating Data Sources, A complete payment management system using ADO and crystal report.

Allows you to automatically generate column headers and load all the records from a table or SQL statement into a listview.

ics1 is a inventory control system. this my first project in vb.

Shows how ADO technology connects globaly. Also shows how to integrate ADO Data Control and the Data Grid. This project uses the phonebook concept to show these concepts.

This small application will allow users to search for contacts by name using a ComboBox. This project shows use of ADO, Search Methods, and Modular programming.