How to save recordset in a txt file and read it later?

[strucnjak79]

well i think I find out how to save it:

qry.recordset.save('C:\filename.txt',0); //what is this number?
[code]

But I'm realy wondering how to read data from file?

 

[DjangMan]

Are you using ADO?

I found this for the second parameter (the number):

Value 	Description
0 	Saves in a Microsoft Advanced Data TableGram 
        (ADTG) format.
1 	Saves in Extensible Markup Language (XML) format
2 	The provider will persist the Recordset using 
        its own format

You'll use the .Open method and specify your filename for the Source parameter.

Regards,

Django