Import data from text file to mdb file
Posted on 2004-08-15
I have a text file with 20000 records, 6 fields each record.
What is the fastest way (in execution time) to import the data into an existing table?
I tryed this code, but it takes more then 2 minutes to add all records.
const TransactionSize as integer = 1000
dr = DataSet.Tables(0).NewRow()
dr(0) = .....
dr(1) = .....
RecordsCount = RecordsCount+1
if RecordsCount = TransactionSize then
RecordsCount = 0