Results 1 to 2 of 2

Thread: Exporting Excel File

  1. Aug 16th, 2000, 07:31 AM #1
    vikoy
    vikoy is offline

    Thread Starter
    Lively Member
    Join Date
    Aug 2000
    Location
    Philippines
    Posts
    85
    Is there any code on how to export a filtered recordset to an excel file?
    Reply With Quote Reply With Quote
  2. Aug 16th, 2000, 08:35 AM #2
    STEVEFLITCROFT
    STEVEFLITCROFT is offline
    New Member
    Join Date
    Aug 2000
    Location
    Lancaster, UK
    Posts
    8

    Export to Excel

    You have to create an excel application object and then
    execute an Insert Into [SHEET1$] Values rs!field1, rs!field2 etc
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width