Results for "Category: Databases/ Data Access/ DAO/ ADO"
Class object that can be compiled or copied and pasted into your application that will dynamically create ODBC DSN's for you.
Class object that can be compiled or copied and pasted into your application that will dynamically create MS Access ODBC DSN's for you.
the engine i am providing is an asp code generator that i am currently using on my website (www.intratelligent.com) to allow asp developers to upload access databases online and build simple asp interfaces to interact with their data. (insert / update / delete and reporting functionality).
I had a datagrid which I needed to output/print, rather than go through the whole printing process I decided to try export it. This code takes values in a datagrid - populated from an access bound datacontrol, and exports the datagrid to a csv file for input into excel.
This sample program is just used to show you how to load the entire Database into a Tree View Control. (*This sample is complete DataEnvironment based.) The Recordset(the Command Object in the Data Environment Designer "Database") can be set by property pages in the designer. But here for the ease to use, I let you browse an Access MDB file. In fact, you can use any type of recordset(Excel, Access, DB, SQL, OBDC...).
This project demonstrates some code concepts such as use of classes, functions, passing variables, and registry control for setting SYSTEM DSN's under ODBC.
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.
Uses DTS (Data Transformation Services) from within VB
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.
This code is a small example that shows you how you can run SELECT Queries on an external Excel File.
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.
This add-in brings up the Data Link Properties Dialog box. From there you pick the provider and the database along with other important information. You then have to option to test the connection. When you click the Ok button the connection string is placed on clipboard ready to be pasted into you code.
Address DataBase Shows VB and ADO
The JC Persistence framework is an abstract database layer that manage transactions in a transparent maner to the developer in any relational database, focused on Object oriented programming, mappings your objects with the database through an XML configuration file.
Give you an idea of how to store your friends information.Please rate me after downloading my work. Thank you! *version 1.1 is out
Give you an idea of how to store your friends information Better version than earlier. Download it now and try it. Please vote me. Thank you!! If any bug please report, thanks.
An alternative method of reading an MS Excel Spreadsheet.
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**
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.