Results 1 to 2 of 2
2001-07-31, 18:52 #1
- Join Date
- Jan 2001
- Serbia and Montenegro (Yugoslavia)
- 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.
2001-08-01, 19:19 #2dave_hillGuest
Re: TransferSpreadsheet Problem (Access 97)
'SpreadSheetTypeExcel97' should be acSpreadSheetTypeExcel97. Access intrinsic constants are prefixed by 'ac'. For lack of a nail...