Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Serbia and Montenegro (Yugoslavia)
    Posts
    342
    Thanks
    0
    Thanked 0 Times in 0 Posts

    TransferSpreadsheet Problem (Access 97)

    I have a form where the onclick event triggers the following code:

    DoCmd.TransferSpreadsheet acExport, SpreadSheetTypeExcel97, "qryBranch", Curdir() & "BranchAssets"

    I get an ODBC call failed, Error 3146. I know I had it working before....what could be wrong? We tried this on another machine as well, same error.

    I have no problem running the query itself, then doing an export to Excel 97 format.

  2. #2
    dave_hill
    Guest

    Re: TransferSpreadsheet Problem (Access 97)

    'SpreadSheetTypeExcel97' should be acSpreadSheetTypeExcel97. Access intrinsic constants are prefixed by 'ac'. For lack of a nail...

Posting Permissions

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