Microsoft Access Unexpected Error From External Database Driver 22
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 unexpected error from external database driver excel of this site About Us Learn more about Stack Overflow the company unexpected error from external database driver (1) Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges unexpected error from external database driver 22 excel Ask Question 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 unexpected error from external database driver (1) excel minute: Sign up Unexpected error from external database driver (22) up vote 0 down vote favorite Here's my code which is in the beginning of a method for converting .xls file to .csv. sourceFile="C:\\Users\\myUser\\Desktop\\Folder\\myFile.xls"; string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + sourceFile + ";Extended Properties=\"Excel 8.0;HDR=No;IMEX=1\""; OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); And it crashes on the last line, throwing this exception: Unexpected
Ms Access 2010 Unexpected Error From External Database Driver (1)
error from external database driver (22). I tried removing the IMEX=1 part, but it still didn't work. What is the problem? c# share|improve this question asked Feb 7 '13 at 7:59 petko_stankoski 3,5621886143 Can you provide us that myFile.xls ? –yogi Feb 7 '13 at 8:04 @yogi It's an excell file with one sheet. The first row has two columns, and all the next have 9 columns. The cells have a background color. –petko_stankoski Feb 7 '13 at 8:07 add a comment| 5 Answers 5 active oldest votes up vote 2 down vote accepted Strangely enough, I replaced the file in another folder and it worked. I have no idea why this is happening. share|improve this answer answered Feb 14 '13 at 7:32 petko_stankoski 3,5621886143 1 Your application needs to be able to open the file with administrator permissions. You probably moved the file to a folder where your application had that level of access. –Ryan Kohn Jul 23 '14 at 13:59 I got this exception. And when I moved my excel file to a different fol
360 games PC games
Unexpected Error From External Database Driver (1309)
Windows games Windows phone games Entertainment All Entertainment unexpected error from external database driver (11265) Movies & TV Music Business & Education Business Students & educators sql server unexpected error from external database driver Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet http://stackoverflow.com/questions/14746308/unexpected-error-from-external-database-driver-22 Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All https://support.microsoft.com/en-us/kb/321003 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
Access Linked Table) If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start http://www.dbforums.com/showthread.php?1610171-Unexpected-Error-from-External-Database-Driver-(MS-Access-Linked-Table) viewing messages, select the forum that you want to visit from the selection below. Results 1 to 2 of 2 Thread: Unexpected Error from External Database Driver (MS Access Linked Table) Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 10-19-06,14:58 #1 hmscott View Profile View Forum Posts Registered User Join Date Dec 2002 Posts 1,245 Unanswered: unexpected error Unexpected Error from External Database Driver (MS Access Linked Table) OS: Windows XP (SP2) App: MS Access 2003 (SP2) DB: MS SQL 2000 (SP4, 2040) User is using MS Access linked table to query database (using ODBC). User can open the query in MS Access. However when the user goes to export the data to MS Excel format, the user receives the error message: "Unexpected Error from External Database Driver (22)." A trace unexpected error from on the db, reveals that the user process is attempting to log in to the server as 'Admin'. However, when the query with the linked table is first opened, the user is prompted for username/password (non Windows authentication). Any ideas? I googled and found some stuff, but nothing directly related and most of what I found was supposedly fixed with SP1. Any help appreciated. I am not an Access guru. Regards, hmscott Have you hugged your backup today? Reply With Quote 10-19-06,15:52 #2 hmscott View Profile View Forum Posts Registered User Join Date Dec 2002 Posts 1,245 Found it. One last detail that I omitted: the user had a new computer built for him. I don't know the precise relationship, but I simply deleted the old linked tables and built new ones. Regards, hmscott Have you hugged your backup today? Reply With Quote Quick Navigation Microsoft SQL Server Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix Microsoft SQL Server MySQL Oracle Pervasive.SQL PostgreSQL Sybase Other Data Access, Manipulation & Batch Languages ASP Crystal Reports Delphi, C etc JAVA Perl and the DBI PHP ANSI SQL Unix Shell Scripts Visual Basic PC based Database Applications Brilliant Database Corel Paradox FileMaker Microsoft Access Microsoft Excel