Re: Recordset to File (MDB or Excel)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



OK. But again, what are you having issues with.

--
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
http://www.veign.com/vrc_main.asp
Veign's Blog
http://www.veign.com/blog
--


"Emma" <Emma@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C06CD66C-F543-4D8F-818C-3509B49D8342@xxxxxxxxxxxxxxxx

The data is coming from a SQL database and I want to save the recordset to
an Excel file or an MDB file so that the users can work with the recordset
locally on their computer. The users also want to use the result in a mail
merge using Word.

"Veign" wrote:

Yes.

What parts are you having issues with? Meaning, you seem to know how to
create a recordset and populate it with data since you want to save it
elsewhere. Are you having issues with the connection to Access or Excel
or
problems with generating the SQL statement?

--
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
http://www.veign.com/vrc_main.asp
Veign's Blog
http://www.veign.com/blog
--


"Emma" <Emma@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BC0559E8-3EB1-4A4E-AEE3-FFF1C77A4FA9@xxxxxxxxxxxxxxxx
Is it possible to save the result of a recordset to an Access MDB or
Excel
file from within VB? If possible, how do I do it?

Thanks
Emma






.



Relevant Pages

  • Re: Saving Web Page Images?
    ... > Chris Hanscom - Microsoft MVP ... > Veign's Resource Center ... > Veign's Blog ...
    (microsoft.public.vb.general.discussion)
  • Re: FTP(not boring)
    ... Chris Hanscom - Microsoft MVP ... Veign's Resource Center ... Veign's Blog ...
    (microsoft.public.vb.general.discussion)
  • Re: Where is Loki Diary?
    ... Chris Hanscom - Microsoft MVP ... Veign's Resource Center ... Veign's Blog ...
    (microsoft.public.vb.general.discussion)
  • Re: DATABASE
    ... >> Chris Hanscom - Microsoft MVP ... >> Veign's Resource Center ... >> Veign's Blog ...
    (microsoft.public.vb.general.discussion)
  • Re: missing DLL file for Sims 2
    ... Chris Hanscom - Microsoft MVP ... Veign's Resource Center ... Veign's Blog ...
    (comp.lang.basic.visual.misc)