Results 1 to 5 of 5

Thread: Export to .xls?

  1. #1
    Join Date
    Nov 2004
    Posts
    90

    Unanswered: Export to .xls?

    Regarding export also...my question is how to export my database (for example 2 table into 2 excell file) as backup into excell? if macro has transfer action how to set it? I've been user transferdatabase action but dont know how to convert my table into excell..and still can't find my table..any idea please suggest...

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    DoCmd.OutputTo acOutputTable, yourTableName, acFormatXLS, "C:\yourOutPutfile.xls"

  3. #3
    Join Date
    Dec 2002
    Location
    Phoenix, AZ
    Posts
    122

    Additional Question

    Is it possible to output to a excel template?

  4. #4
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Quote Originally Posted by cc3658
    Is it possible to output to a excel template?
    DoCmd.OutputTo acOutputTable, yourTableName, acFormatXLS, "C:\yourOutPutfile.xlt"

  5. #5
    Join Date
    Nov 2004
    Posts
    90
    Thanks,

    it ok if export in other format or database format...I already try to use the code given but module debug say 'can' find project or libraray'. that mean it cant find my table...the directory in "c:" right? is it ok if the table that I want to export is in relationship format or my table need to declare in code? any idea on using macro? it because I wanna make 4 function in one command button such as print record,export,delete and import new record.
    any idea please help...

Posting Permissions

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