Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2007
    Location
    Columbia SC
    Posts
    81

    Unanswered: can't find the object.

    Hey,
    I am exporting to excel with the statement

    DoCmd.TransferText acExportDelim, , "qryToExport", s, True
    but as i click save.
    I recieve the error can't find the object.

    where qryToExport is a view not table.
    Is there any other way if i want to make use to views rather than table?

    Thanks

  2. #2
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    TransferText does not export to Excel; TransferSpreadsheet does. I suggest you consult the help file. Also, where's the filename argument? That's probably why you get the error can't find object.

    Sam

  3. #3
    Join Date
    Jul 2007
    Location
    Columbia SC
    Posts
    81
    I did that.
    I created a stored procedure which on the fly creates a table and then i used table in this statement.
    Working now
    Thanks

Posting Permissions

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