Save a recordset to a file?

[gusbrunston]

[tt]
Hi:

Is it possible to save a recordset to a file (not a database) outside the database?

I've tried this code on a command button, however...

Private Sub Command0_Click()
Dim rsChecks As Database
Set rsChecks = CurrentDb()
rsChecks.Save "c:\Datamaster\Database\Checks.dat"
rsChecks.Close
End Sub

I get an error "Compile error: Method or data member not found"

Thanks,
[tt] Gus Brunston - Access2000(DAO)[/tt] Intermediate skills.

 

[JoanneM]

Gus

I had your problem with twiddly bits so I wrote the code.

what type of file do you want it to go to?
mine does word,excel, rtf with incremental naming conventions ( for those managers that can't read what date a report was generated - they just has to pick the name with the biggest number at the end)

If you provide email I will send you the full code ( twiddly bits included) - that goes for any of you guys out there.

Documentation in it is succinct but clear (I HOPE)
regards

jo

 

[gusbrunston]

[tt]
Dear JoanneM:

Thank you very much. padregus@attbi.com [tt] Gus Brunston - Access2000(DAO)[/tt] Intermediate skills.

 

[EliseFreedman]

Hi Gus

I use Visual Basic and ADO to copy a MS Access Recordset to a file outwith the database.

Feel free to e-mail me if you want a sample of the code. My e-mail address is elisefreedman57@aol.com