Home
Search
 
What's New
Index
Books
Links
Q & A
Newsletter
Banners
 
Bookstore...
 
Feedback
Tip Jar
 
XML RSS Feed
 
 
MSDN Visual Basic Community
 
 
 
 
 
 
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-2008 Rocky Mountain Computer Consulting, Inc.   All rights reserved.
  Updated