Ms Access Runtime Error 3275
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers "unexpected error from external database driver (1)" or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question
Transferspreadsheet
x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up DoCmd.TransferSpreadsheet triggering Error 3275 “unexpected error from external database driver” up vote 1 down vote favorite A week ago, I build a form with a host of buttons to run queries between certain dates in my database, and then export those dates into an excel file. Over the past couple days, I expanded the capability to support custom file locations, sheet names, and source table names. I did all of this so that the tool is useable by whoever comes after me (I'm an intern). About an hour ago, however, I started getting the error message Run-time error '3275': unexpected error from database driver (1) in a pop-up box. I can't upload pictures directly yet, but here is a picture of the structure of my form. My code is below: Private Sub SendToExcel_Click() DoCmd.TransferSpreadsheet acExport, , "TBL_XL_DATA", _ "X:\Confidential\Weekly Intel.xlsx", _ \\The file location is here in the actual code True, "Input" End Sub This is the 'default' export option, which I have not modified in any way over the past few days. The new function is as follows: Private Sub CustomToExcel_Click() DoCmd.TransferSpreadsheet acExport, , [Forms]![Date Range]![SourceTable], _ [Forms]![Date Range]![FileDest], _ True, [Forms]![Date Range]![SheetName] End Sub I found a similar question, with the same error, and using TransferSpreadsheet, but I don't think my problem is the command running too slowly, expecially considering I ran it (the newer command) an hour ago without trouble. I am perplexed as to why the command doesn't work now, and why the unchanged command that I haven't dealt with in a while is also now throwing the same error. I am hoping someone understands enough about the error itself to give me a suggestion or two. What should I look for? What should I tinker with to get more information about it? Found the solution in an obscure forum. My problem is that my path is too long for transferspreadsheet to handle. I am in luck, since my database and excel file are in the same folder. I am sure there is a way to have longer paths be supported, so if anyone knows h
Need help? Post your question and get tips & solutions from a community of 418,595 IT Pros & Developers. It's quick & easy. docmd.transferspreadsheet unexpected error P: n/a user_5701 Hello, I'm getting an error with a Docmd.Transferspreadsheet line of code: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel2000, "tblTest", pathAndFilename, True The above line works perfectly fine, but when I change the table name argument (tblTest) to the name of a query, it fails and gives the following error: Runtime error 3275 Unexpected error from external database driver (22). The help file with Access 2000 states that it is possible to use a query instead of a table name, but a sql statement cannot be used - it http://stackoverflow.com/questions/17459343/docmd-transferspreadsheet-triggering-error-3275-unexpected-error-from-external must first be saved in a query. I'm not using an sql statement, but rather a saved query, and I still get the error. According to the help file this should be working: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel2000, "qryTest", pathAndFilename, True Anybody have any ideas? Thanks in advance. Nov 13 '05 #1 Post Reply Share this Question 3 Replies P: n/a Salad user_5701 wrote: Hello, I'm getting an error with a Docmd.Transferspreadsheet line of code: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel2000, https://bytes.com/topic/access/answers/202437-docmd-transferspreadsheet-unexpected-error "tblTest", pathAndFilename, True The above line works perfectly fine, but when I change the table name argument (tblTest) to the name of a query, it fails and gives the following error: Runtime error 3275 Unexpected error from external database driver (22). The help file with Access 2000 states that it is possible to use a query instead of a table name, but a sql statement cannot be used - it must first be saved in a query. I'm not using an sql statement, but rather a saved query, and I still get the error. According to the help file this should be working: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel2000, "qryTest", pathAndFilename, True Anybody have any ideas? Thanks in advance. Do you have a small lookup table to make a test on? One that has 3 or 4 records? Create a query on that table. A real simple one. Ex: Select ID, Description From LookupTable; Does it work on your machine? If so, then there is something in your query that is causing a problem. Does you query have subqueries in it? Does it have have a function call...ex NZ(), CINT(), or custom functions you have written? Is it a Totals query where you are grouping the results? Do you have calculated fields in it? IOW, is the query a simple select query or is it a co
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask https://www.experts-exchange.com/questions/21915912/run-time-error-3275-Unexpected-error-from-external-database-driver-10019.html a Question Ask for Help Receive Real-Time Help Create a http://www.pcreview.co.uk/threads/importing-from-excel-using-docmd-transferspreadsheet.1675010/ Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > run time error 3275 ms access Unexpected error from external database driver 10019. Want to Advertise Here? Solved run time error 3275 Unexpected error from external database driver 10019. Posted on 2006-07-11 MS Access 1 Verified Solution 13 Comments 2,268 Views Last Modified: 2007-12-19 Hi experts, I am running a module that used to creat a ms access runtime table for me, and now is creating a problem. I wrote this in access 2000, and havd 2003 now. What is wrong? Function Posting_Types() Dim db As Database Dim tb As TableDef Set db = CurrentDb() ' Deleteing existing Graph Data if it exists For Each tb In db.TableDefs If tb.Name = "POSTING TYPES" Then DoCmd.DeleteObject acTable, "POSTING TYPES" Exit For End If Next 'busy cursor Screen.MousePointer = 11 db.Execute "SELECT POSTDAT.DATESTAMP, POSTDAT.POST_CD, POSTDAT.POST_DT, IIf([post_cd]='1',[post_amt],0) AS ins1, IIf([post_cd]='2',[post_amt],0) AS ins2, IIf([post_cd]='3',[post_amt],0) AS ins3, IIf([post_cd]='4',[post_amt],0) AS ins4, IIf([post_cd]='P',[post_amt],0) AS patpay, POSTDAT.POST_AMT, POSTDAT.POST_UNCOL, POSTDAT.POSTINS, PATDATA.PAT_BC, PATDATA.PAT_LC INTO [POSTING TYPES]" _ & " FROM PATDATA INNER JOIN POSTDAT ON PATDATA.PAT_ACCT = POSTDAT.PAT_ACCT;" Set db = Nothing Screen.MousePointer = 1 End Function 0 Question by:Quadeeb2003 Facebook Twitter LinkedIn Google LVL 39 Best Solution bystevbe I checked out the 10019 error message ... ?AccessError(10019) SCRATCH can't find the database containing the linke
David Cleave Guest Hi all When this command runs, everything stops and I get the following error: Run-Time error 3275 Unexpected error from external database driver (22). I'm trying to import data from an Excel 5.0 workbook (not that it makes any difference if I update it to 7). The full command is: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel5, "PWA Employees for Update", "G:\Training\all employees update from pwa to tim.xls", True Anyone got any good ideas what this is about? Cheers David David Cleave, Jul 16, 2004 #1 Advertisements Guest Guest I should point out the specific error I'm getting is: Unexpected error from external database driver (22). There's nothing at all about this on the web. Why do I always get the beauties? David Guest, Jul 16, 2004 #2 Advertisements Ken Snell Guest Likely the error is caused by the length of the filename and/or the combined path and filename. Try renaming the file to an 8-character file name and try it. -- Ken Snell