Viewable by all users Your answer toggle preview: Attachments: Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total. cnPMCustomers.Open strConn ' declare the variable, strPhoneNum as a string Dim strPhoneNum As String ' Direct variable name where to get value strPhoneNum = ActiveWorkbook.Sheets("Sales Invoice").Range("B10").Value Debug.Print (strPhoneNum) ' declare strSQL It occurs at the Code: cnPMCustomers.Execute strSQL I also went through the rest of the code and did not find any other single quotes R Share Share this post on Digg Thanks. have a peek at this web-site
Fix the Vlookup ... There were a few potential problems, and conventions(lack thereof) that could have been causing problems, or by their nature were extremely prone to causing problems. It is possible that there is another issue in that string but the error is pretty specific. Helpful Excel Macros Excel Macro to Save a Specific Worksheet as a New File - This Excel Macro allows you to save a specific worksheet within the Excel Workbook to its
Downloading now to have a look at it Reply With Quote Jun 12th, 2012,09:35 PM #23 aldryn05 View Profile View Forum Posts Visit Homepage Thread Starter Member Join Date Jun 2012 thanks in advance Ask Your Own Question Error Message: "compile Error. Reply With Quote Jun 12th, 2012,08:29 PM #17 aldryn05 View Profile View Forum Posts Visit Homepage Thread Starter Member Join Date Jun 2012 Location San Pedro, Laguna, Philippines Posts 62 Re: Please help!!!!
Reply With Quote Jun 13th, 2012,11:20 AM #32 Bobbles View Profile View Forum Posts Fanatic Member Join Date Dec 2008 Posts 779 Re: Run-time error '-2147217865(80040e37)' Originally Posted by DataMiser So Code: Sub GetExcelDataToAccess_ADO() ' exports data from active worksheet to a table in an Access database Dim cn As ADODB.Connection, rs As ADODB.Recordset, i As Long, lastrow As Long ' connect Copyright BetaSoft Inc. Your problem is being caused by the: 'RecSet.Open SQLQuery, Conn ' statement.
Acc2013x64 up vote 0 down vote favorite I've successfully used ExcelADO for reading and importing Excel data into MSAccess during long time reading the entire SpreadSheet. If your string is something like Code: Select * from 'tblLogIn' ..... Are you running the program by doing ALT fsrf (Holding down the ALT key and asking for File Save Run with Full compile) Can you prepare a trimmed down copy of im thinking on how did you know what really the problem, aside from the table name..
The error insicates a problem with the table name in the sqlString. Runtime Error -2147217865 (80040e37) Invalid Object Name jinu john asked Oct 10, 2012 | Replies (6) Dear VB Gurus, I was using a VB6 application running successfully with database connection string but, thanks! If it did not then that would mean either you are getting an error somewhere else or you are not looking at the debug/immediate window or you entered it incorrectly.
Based on the output of these statements, you may be able to work out what's wrong. Make sure it exist and its name is spelled correcty.. Runtime Error 80040e37 Invalid Object Name When I try and use the code, I get the following error on the ASP pages: Microsoft OLE DB Provider for ODBC Drivers error '80040e37' 80040e37 Active Directory Dim strConn As String 'Use the SQL Server OLE DB Provider.
Explanations will follow Attached Files ROB_Run-time_error_-2147217865_80040e37.zip (63.9 KB, 386 views) Reply With Quote Jun 12th, 2012,11:21 PM #29 Bobbles View Profile View Forum Posts Fanatic Member Join Date Dec 2008 Posts http://prcflow.com/runtime-error/microsoft-visual-c-runtime-library-runtime-error-r6025.html Get 1:1 Help Now Advertise Here Enjoyed your answer? stSQL1 = "SELECT * FROM query_test" 'The 2nd raw SQL-statement to be executed. can anyone help me? 2147217865 Invalid Object Name
John Turner replied Oct 16, 2012 A good resource is http://www.connectionstrings.com/. Reply With Quote Jun 11th, 2012,12:57 AM #10 DataMiser View Profile View Forum Posts PowerPoster Join Date Feb 2012 Location West Virginia Posts 11,029 Re: Run-time error '-2147217865(80040e37)' You highlighted it Will I encounter any problems as a recognizable Jew in India? http://prcflow.com/runtime-error/0x800a138f-microsoft-jscript-runtime-error-object-expected-mvc-4.html Was the table actually Named Login or was it tblLogin in the database?
What is the exact error message that is appearing when you run the program now? The question is: How can I close the connection to Excel with VBA without closing the complete Excel file? I have checked the name and its being spelled correctly and don't know where the problem is occuring.
It indicates a bad table name in the sekect string. According to the documentation http://support.microsoft.com/kb/278973, the only thing that needs to be changed is the From clause in the SQL string: oRS.Open "Select * from Table1", oConn, adOpenStatic However this fails Here is the code i have used. i used the same parameters as i was doing it in DSN less,and it worked.
Lotte Code: Private Sub Worksheet_Change(ByVal Target As Range) Dim DBFullName As String Dim TableName As String Dim TargetRange As Range Dim cnn As ADODB.Connection Dim rs As ADODB.Recordset Dim intColIndex As Any comments in this matter would be appreciated. If Conn.State <> 0 Then Conn.Close End If Set Conn= Nothing Don't think this will help much but I'll have a think... have a peek here When you use Debug.Print, it prints the result of the Debug.Print statement there, not in your application nor in a messagebox.
The IP list is in the database in a table called tbl_IP_list. Share Share this post on Digg Del.icio.us Technorati Twitter Richard Schollar Using xl2013 Reply With Quote Sep 24th, 2007,05:02 PM #6 RTFentem New Member Join Date Sep 2007 Posts 5 Hello Dim cnPMCustomers As ADODB.Connection Set cnPMCustomers = New ADODB.Connection ' Provide the connection string. This article will help you to understand Proxy and when it is useful.
Thanks in advance, Diego Edit: Well, the error is right in the sense that my object Table1 is not present in the schema as evaluated by using: Set rs = cnn.OpenSchema(adSchemaTables) Reply With Quote Jun 11th, 2012,12:29 AM #5 aldryn05 View Profile View Forum Posts Visit Homepage Thread Starter Member Join Date Jun 2012 Location San Pedro, Laguna, Philippines Posts 62 Re: The Problem is, as long as I have opened the Excel File, I can't edit the Access Database (read-only).