GeraldB13
Jul 31st, 2000, 01:31 PM
Hello Folks,
Is there a way to import a large fixed field .txt file into an Access Table using Visual Basic 6 (not using VBA DoCmd.TransferToText) without relying upon either:
1. executing an SQL INSERT command for each line of text OR
2. executing rs.AddNew for each line of text then performing
rs.UpdateBatch.
These methods are obvious but slow. I'm wondering if I'm overlooking yet another (faster) way. Thanks!
Is there a way to import a large fixed field .txt file into an Access Table using Visual Basic 6 (not using VBA DoCmd.TransferToText) without relying upon either:
1. executing an SQL INSERT command for each line of text OR
2. executing rs.AddNew for each line of text then performing
rs.UpdateBatch.
These methods are obvious but slow. I'm wondering if I'm overlooking yet another (faster) way. Thanks!