Ms 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
Unexpected Error From External Database Driver Excel
have Meta Discuss the workings and policies of this site About unexpected error from external database driver 22 excel Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads
Unexpected Error From External Database Driver (1)
with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million unexpected error from external database driver 11265 paradox programmers, just like you, helping each other. Join them; it only takes a 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 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 pe
FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This http://stackoverflow.com/questions/14746308/unexpected-error-from-external-database-driver-22 Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Microsoft: Access Other topics Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesMicrosoft: Access Other topics Forum Unexpected Error from External Database Driver (22) thread181-54779 Forum Search FAQs Links MVPs Unexpected Error from External Database http://www.tek-tips.com/viewthread.cfm?qid=54779 Driver (22) Unexpected Error from External Database Driver (22) Sorrells (Programmer) (OP) 13 Feb 01 11:14 This error has occurred to two people in our company when exporting the dynaset of an Access97 query to an Excel spreadsheet. One of these people has performed the export for over a year, then a month ago she began getting this error. All of our users have their own copy of Office97 on their workstations. Has anyone out there experience this error and know the cause?My thanks in advance for any help/advice offered.Sorrells RE: Unexpected Error from External Database Driver (22) RobTsintas (TechnicalUser) 13 Jan 04 10:49 I would like to bump this (very old) thread up the list, as I am getting the same error and cannot find a solution elsewhere.I am simply trying to export the results of a select query as an excel file using the following VB code:DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "rtData_for_Not_Included_Spreadsheet", "C:\Tmp\Data for Not Included Spreadsheet.xls"The Excel file is created in the required folder, but it is empty.Hope someone can help.... RE: Unexpected Error from External D
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 viewing messages, select http://www.dbforums.com/showthread.php?1610171-Unexpected-Error-from-External-Database-Driver-(MS-Access-Linked-Table) 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… http://www.vbforums.com/showthread.php?532733-Unexpected-error-from-external-database-driver-(8458) 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 from External unexpected error 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 on the db, reveals that the user unexpected error from 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 Other PC Databases General New Members & Introductions Applications & Tools Database Concepts & Design
driver (8458) 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 viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: Unexpected error from external database driver (8458) Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Jul 22nd, 2008,04:02 PM #1 mel_flynn View Profile View Forum Posts Thread Starter Frenzied Member Join Date Nov 2001 Posts 1,384 Unexpected error from external database driver (8458) Hi all, I have been linking dfb files to MS Access 2003 for some time, always reading successfully (my VB app runs queries using these linked files). My client updated to Access 2007 a couple of months ago and again it was sucessfully reading the .dbf files until last week. Suddenly they are getting the error: Unexpected error from external database driver (8458) Thinking that maybe the dbf files were corrupt I tried linking and importing other .dbf files but get the same error. I transferred the files to another PC with Access 2007 and can successfully read the files. I have tried reinstalling Office 2007, installing Office 2007 SP1, and WinXP Pro SP3. I have also tried reinstalling MDAC and I have uninstalled Access 2007 but am still getting the same problem. Of course, I can't find any reference to this error on Microsoft website for 2007, only for 2000. Have tried the suggested fixes but no luck. Any ideas??? Mel Reply With Quote Jul 23rd, 2008,02:39 AM #2 Ecniv View Profile View Forum Posts Visit Homepage Don't Panic! Join Date Nov 2000 Location Excel Hell! Posts 5,044 Re: Unexpected error from external database driver (8458) Had a look on google - seems to be that the dbf file type has changed and perhaps access doesn't read it too well. Concensus seems to be export the dbf as csv and reimport back to access. Some posts on other forums mention that the memo in Alpha holds pictures as well... uh right. Other mention a conspiracy of MS to not support external file types as well. Have a quick search on Google for the title of your post. good luck If you do manage to find a fix pls post up incase it happens to me in the future I would like to know a way to make it wor