paul.hartland at fsmail.net
paul.hartland at fsmail.net
Wed Jan 28 03:28:17 CST 2004
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. I’m 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 _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com