[dba-VB] Text File Into Access Using Visual Basic 6

Seth Galitzer sgsax at ksu.edu
Wed Jan 28 08:09:25 CST 2004


Have a look at the downloads on my website.  I have sample code for file
I/O in VB.  The code was written for Access, but is generic enough it
should work in VB without a problem.  I use DAO in there for database
access, but you can easily substitue ADO if you prefer.


On Wed, 2004-01-28 at 03:28, paul.hartland at fsmail.net wrote:
> To all,
> Can anyone tell me (preferably with sample code, if possible), what is the fastest way to import a .txt file into a predefined table in access via Visual Basic 6.
> My .txt file contains roughly 365,876 records with two fields  Barcode, Price.  This has to be imported into an Access table also containing two fields Barcode (text), Price (Number, Double, Fixed, 2 decimal places).  
> The .txt file is comma delimited.  Im using Access XP and Visual Basic 6.0 as the front-end.
> Thanks in advance for any help as, this project needs to be ready for Monday morning
> Paul Hartland
> Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month 
> www.freeserve.com/anytime

Seth Galitzer			sgsax at ksu.edu
Computing Specialist		http://puma.agron.ksu.edu/~sgsax
Dept. of Plant Pathology
Kansas State University

More information about the dba-VB mailing list