04-15-2003, 03:43 PM
Join Date: Jan 2003
Location: Wantage, Great Britain
ISAM/ODBC text import - Maximum number of records?
I'm importing some data from a text file into a Access database using
Set db = New ADODB.Connection
db.CursorLocation = adUseClient
SrcFileName = MyPath & "alldata.txt"
db.Open "PROVIDER=MSDASQL;dsn=Text Files;uid=;pwd=;database=alldata.txt;"
Set adoPrimaryRS = New ADODB.Recordset
tblName = "ImportData"
strSQL = "insert INTO " & tblName & " (fld1, fld2, fld3, fld4 ) " & _
"IN '" & strMyDbNamePub & "' " & _
"select fld1, fld2, fld3, fld4" & _
"from " & SrcFileName & ";" '& _
adoPrimaryRS.Open strSQL, db, adOpenStatic, adLockOptimistic
The code works fine, but I seem to remember reading somewhere that
there is a limit to the number of records you can import in one go using this method.
Hitting the limit wouldn't be much of a problem, but does anyone know what the limit is?