|MDB2DBC - Access to VFP Data Migrator|
Wednesday, January 17th, 2001 at 11h11
This is the followup to DBC2MDB which moves Fox data to Access. This file does the opposite; moves selected contents of an Access MDB file to a new or existing VFP DBC and DBFs. Supports just about all data types except General-type fields.
|Rating:||4.00/5.00 (5 rates) Rate this entry|
|John Koziol |
Requires VFP6 (any flavor) and Access 2000 or better. Has not been tested with Access projects (.ADP files) using SQL Server or MSDE but might work. Also might work with VFP 5.0.
More entries from this member
- An Evil Bag of Tricks October 13, 1999
Bag-o-tricks is a lighthearted VFP6 classlib with classes designed to be dropped into forms to produce strange behavior. It is totally nondestructive and will not harm a fly. Have fun with this!
- Automated Data Functions November 18, 1998
Autodata is a collection of 4 procedures that automate saving, validating, requerying, and reverting DataEnvironment cursors and views.
Autodata is completely automated and uses simple forced tableupdates. It is easy, however, to graft more sophisticated conflict management in an automated fashion into it as views and tables are managed through a collection object and not explicitly.
Autodata requires VFP6 to run as it employs AddProperty. It will work with
VFP5 if the new properties ...
- Check functions Class for VFP6 September 30, 1998
GENCCLASS defines a class called CheckFunctions with a simple property set to convert numbers to printed check-style text.
For example: 112.20 = One hundred twelve Dollars and 20 Cents.
The class will work in Spanish or English via a Language property.
It makes heavy use of HIDDEN properties and methods and uses the new ASSIGN to mask the implementation of the conversion from the method of the conversion.
Further information and usage examples may be found in the program heade...
- DBC2MDB - Fox to Access Downsizer January 15, 2001
The Upsizing Wizards in VFP help us move our data and database schema to Oracle or SQL Server. But what about "downsizing" to Access?
DBC2MDB is a wizard that allows you to move your database and table structure to a new or existing MDB and, optionally, move the data itself.
- DESI - Digital Elite Simple Invoicing October 19, 1999
DESI is a complete application written under VFP6 SP3. It maintains clients and can produce invoices. It's a simple application, but includes a simple framework, a database container, and a fair amount of sample code.
The purpose of this application is to show how everything can be put together for a complete application. It does work!
Version 1.10 changes -- Invoices customizable via an Options screen. New class introduced for modal dialogs. Some OOP-oriented changes.
- Evolution December 15, 2006
This simple program simulates organization from chaos, such as assembling an RNA chain from an amino acid soup. Type in long phrases and amaze your friends how they can be matched randomly in a relative few generations!
- GenLoader - a WSH Loader Script Wizard April 21, 2001
GenLoader creates Windows Script Host scripts that you can use as loaders for Visual FoxPro applications to check for (and replace with) newer versions of the application.
- GenOrdinal January 12, 2006
Simple class to convert numbers to ordinals on the fly, ie, 23 to twenty-third. If operates using the _Assign event to automatically handle the conversion. The resulting Verbiage property is upper-case (so use VFP's PROPER or LOWER if desired).
- ILX - Inline Expression Evaluator August 9, 1999
conILX is a container that you can dump into any Form. It is an expression evaluator, allowing you to test expressions without using the Debugger. It tracks multiple expressions (no limit). It has the ability to 'lockdown' expressions and save results to a textfile.
NEW: Now allows the entry and evaluation of collections and arrays.
- LS - LIST STRUCTURE Replacement October 28, 1999
Get annoyed by those word-wrapping list structure printouts? LS replaces the command by formatting the output to comfortably fit on the screen or on a printed page (in landscape mode), or in Print Preview.
- Outlook-style Name Parser October 5, 2000
This simple class accepts a name in standard first and last name format and then formats it into last, first format. What makes it unusual is that it can handle prefixs, suffixes, and titles with aplomb.
Steven Dingle will soon be posting a class on Compuserve that does this same thing in a slightly different fashion.
Concept and Table Structure: Steven P. Dingle
Implementation: John Koziol
- Printer Control Functions September 15, 1999
VBPrinter is an ActiveX control that allows precision control over printers not afforded by native VFP functions. It allows for programmatic selection of paper bins, orientation, copies, paper size, and much more. This is a "don't miss" if you require extended printer control functionality. This update includes the addition of a few more updates as well as an Include file to support constant use.
- ROC - Raid Outlook Contacts September 10, 1999
ROC grabs Contacts from Microsoft Outlook 97 or better and puts them into a DBF. Not all properties are "raided", but this simple demo program should help you learn more about the Outlook object model and how to "raid" other things.
- Spellbound - Integrated Word Spellcheck October 28, 1999
Spellbound is a classlib with a single class, SpellIt. SpellIt is used as a means to spellcheck (with suggestions, changes, and all the other Word spellcheck amenities) any text value.
Designed in VFP 6 SP3, but should work if compiled under VFP 5.
- Textbox for Numeric Expressions July 30, 1999
The zip file contains a classlib, class, a dummy table and test form to show a TextBox that allows entry of numeric expressions, like 34+67, and then displays the result. This class requires that the textbox be bound to a numeric or integer column in a table.
- The Vulcan Class for VFP6 September 30, 1998
Create your own Mr. Spock in VFP6. At the Command Window, do 'Spock=NEWOBJECT("Vulcan","StarTrek")' From then on, you can get one of Mr. Spocks insights by typing ?Spock.Opinion, just like Captain Kirk!
This classlib demonstrates the Access method.
- Time Entry TextBox Class September 4, 1998
This is a simple class to allow formatted and validated entry of 12-hour time values into a textbox, ex: 11:14 PM.
Thanks to Robert Keith for starting the thread which led to the idea.
- UnDE - DataEnvironment decoder April 7, 1998
Creates program code in a separate PRG file to emulate actions of the DataEnvironment. Useful in converting from using a DE to using hard-coded table openings, buffering, relations, etc.
- VFPLife - The Math Game of Life for VFP April 14, 2001
The mathematical evolutionary game of Life.
- ViewMaster November 20, 1998
ViewMaster (.09 Beta) is a Visual Tool for VFP6 databases that allows you to edit any local or remote view property or field property. Changes may be applied to the DBC or reverted.
- World Currencies August 17, 1999
This is a Visual FoxPro DBF of countries, currency name, and official currency code. Nothing more, nothing less.