Import a Delimited Text File into a Database

Category:
Database
Type:
Snippets
Difficulty:
Intermediate

Author: Intelligent Solutions Inc.

Version Compatibility: Visual Basic 6

More information:
This example imports a text file into a database table using ADO. Because it uses ADO, it should work with all data sources, though it has only been tested with Access. Usage is explained in the code's comments.

Instructions: Copy the declarations and code below and paste directly into your VB project.

Declarations:

Code: