Home
Search
 
What's New
Index
Books
Links
Q & A
Newsletter
Banners
 
Feedback
Tip Jar
 
C# Helper...
 
XML RSS Feed
Follow VBHelper on Twitter
 
 
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-2010 Rocky Mountain Computer Consulting, Inc.   All rights reserved.
  Updated