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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

bulk copy to Excel 2
How to speed up Bulk Insert? 1
INSERT INTO table from recordSet?? 2
ADO - delete/ update recordsets 5
INSERT INTO table FROM Persisted Recordset? 3
Dim rs as recordset or object? How to check if an rs is open? 39
Copy ADO Recordset 2
Recordset with SQL strings 1

Back
Top