Home
 
What's New
Index
Books
Links
Q & A
Newsletter
Banners
 
Feedback
Tip Jar
 
 
 
Old Pages
 
Old Index
Site Map
What's New
 
Books
How To
Tips & Tricks
Tutorials
Stories
Performance
Essays
Links
Q & A
New in VB6
Free Stuff
Pictures
 
 
 
 
 
 
 
TitleUse ADO to convert between various database formats
KeywordsADO, database, Jet, Access, dBase, Paradox, Excel, text files, HTML
CategoriesDatabase
 
By Toby Bascom

This project is a "Jet Conversion Machine" (VB6/ADO) which makes conversions to/from the following file types:

  • Access
  • dBASE
  • Paradox
  • Excel
  • Text
  • HTML

The SQL generated is regurgitated to a multiline textbox from which it can be copied to the clipboard:

When run, this project will create a number of subdirectories so be sure to first create a subdirectory where it can be unpacked. Note also, that the project will create an MDB (Southwind.mdb) in the subdirectory and subsequently create and load a table using data taken from a text file (customers.txt). The "schema.ini" (also present) gives the blueprints for the table.

See the code for further details.

 
 
Copyright © 1997-2001 Rocky Mountain Computer Consulting, Inc.   All rights reserved.
  Updated