Bulk Insert into disconnected recordset

  • Thread starter Thread starter GPO
  • Start date Start date
G

GPO

Access 2000
Is it possible to take the contents of a text file and bulk insert them imto
a disconnected recordset?
(The recordset would simply be one field, and each line of the text file
would be one row of the recordset) The main issue is the bulk insert.

Cheers GPO
 
I suspect you want to link to the file as if it were a table. Go ahead and
try to create a new linked table, but choose "Text Files
(*.txt;*.csv;*.tab;*.asc)" in the "Files of Type" combo at the bottom of the
Link dialog box, and pick your file from the appropriate folder.
Now that you've got a "table" you can reference it in the Tables collection
with VBA code.
 
Back
Top