excel error data could not be retrieved from database Coalinga California

CalDSL provides high-speed internet service to homes and businesses located in rural and under served areas in San Joaquin and Calaveras counties in Northern California.

Broadband Internet Commercial Services Residential Services

Address 1660 W Linne Rd, Tracy, CA 95377
Phone (209) 832-4420
Website Link http://www.caldsl.net

excel error data could not be retrieved from database Coalinga, California

Code: With .ListObjects.Add(SourceType:=0, Source:=Array( _ "OLEDB;Provider=Microsoft.ACE.OLEDB.12.0;Password="""";User ID=Admin;Data Source=" & sFULLNAME & "" _ , _ ";Mode=Share Deny Write;Extended Properties="""";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Database Password=""""" _ , _ ";Jet OLEDB:Engine Type=6;Jet And thank you very much for responding. Ii would like to import data from an access database into an excel pivottable using the connection.add method in vba. You cannot edit other topics.

coinsidentally, had a similar problem recently with another query, TimeValue function is acting up, i think. Other recent topics Remote Administration For Windows. However, it does not allow you to choose the input cells to act as the inputs to the stored procedure. Thread Tools Display Modes

#1 (permalink) December 1st, 2006, 06:30 AM vincerhodes Registered User Join Date: Nov 2006 Location: , , .

All contents Copyright 1998-2016 by MrExcel Consulting. Tony Czeszyn View Public Profile Find More Posts by Czeszyn

« Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page currently I have been able write the following code Code: Sub Macro2() ' ' Macro2 Macro ' ' With ActiveSheet.ListObjects.Add(SourceType:=0, Source:= _ "ODBC;DRIVER=SQL Server;SERVER=PNWEBSERV01;UID=pnxlreader;PWD=LimsPass01;APP=Microsoft Office 2010;WSID=PNDTP056V64;DATABASE=PNLMDB" _ , Destination:=Range("$C$6")).QueryTable .CommandText = Next, I set up a query to pull the last record using the autonumber and a report pulling the info from a second query (getting the last record from the first

Neither of the following code works for me: Code: Sub macro1() Dim i As Byte With CreateObject("ADODB.Connection") .Open "provider=microsoft.jet.oledb.4.0;extended properties='excel 8.0;HDR=NO;';data source=" & ThisWorkbook.Path & "\book1.xls" For i = 1 To We need your input to help create a new Live Online Excel Help service. Russ Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote « Previous Thread | Next Thread » Like this thread? Anyway, I want to put a formula into the criteria to only select rows within a range of data.

Any help is appreciated. All rights reserved. When I got an error, I read other people's frustrations with the same issue and then tried all solutions that I have read so far, including copying the .htaccess folder which The question is: How can I close the connection to Excel with VBA without closing the complete Excel file?

now i get this error: 'Data could not be retrieved from the database. Access has [Part Number] as the Criteria. My blog at SQLKover. Do the program in 6 Steps : http://delphi.about.com/od/database/l/aa090903a.htm *** LOOK CONNECTION STRING SECTION BELOW !

In the worst case, copy and paste the data from the tables to Excel. The thing that does not make sense is that it worked great the first time, then stopped. All i managed to write until now is: Code: Private Sub Form_Load() Dim Cn As New ADODB.Connection Dim strCNString As String Dim RS As New ADODB.Recordset 'Connect to database strCNString = You cannot delete other posts.

Thanks, Jimmy Ask Your Own Question Macro To Change Odbc Connection String - Excel Excel Forum I am trying to change the SQL command to an odbc database connection Code: Sub Open Access, then click File > Open, then browse to the file, then in the lower right corner, select Open Exclusive. Make sure the external database is available, and then try the operation again. Thanks David Monday, May 12, 2014 5:51 PM Reply | Quote 0 Sign in to vote I have the same issue except with SQL Server.

there is nothing else to the data base. Now I also found this: http://p2p.wrox.com/excel-vba/29037-...has-1-rpt.html which makes it out to be a bug in excel and that I need to change the type of connection, then change the string, then please help... Czeszyn View Public Profile Find More Posts by Czeszyn

09-22-2015, 05:37 AM #2 Ranman256 Newly Registered User Join Date: Apr 2015 Location: KY,USA Posts: 1,484 Thanks:

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. I have no problem using an ODBC connection. Any input would be very helpful. Check the database server or contact your ..blah.

Welcome to the p2p.wrox.com Forums. However I finding that sometimes users get the following error: Error Number: -2147467259 Error Description: Could not use ''; file already in use. Thread Tools Rate Thread Display Modes 09-22-2015, 05:32 AM #1 Czeszyn Newly Registered User Join Date: Oct 2014 Posts: 114 Thanks: 29 Thanked 1 Time in 1 Post Data Works (ODBC) obj.Connection = "ODBC;DRIVER={Microsoft ODBC for
Oracle};SERVER=IFAS;UID=scott;PWD=tiger" Doesn't work (OLEDB) obj.Connection = "OLEDB; Provider=MSDAORA; Data Source=ifas; User ID=scott; Password=tiger;" Does a DSN need to be created for OLEDB connections?

With my "normal" queries I've been able to do this in this manner: Range("A" & intLineNum).Value = rst1!dataName and proceeding through the different values. When the main excel file is open (connected to different data sources) all the data source files when accessed open as READ-ONLY. Those are the default settings. As a guest, you can read any forum posting.

By using the external 'Connection type' of Database Query (by originally choosing to insert an External Data source from MS Query), Excel allows you to pass parameters through to a stored You cannot edit HTML code. I was wondering if it's possible to embed the password in the code so it doesn't ask for it. here is an example of one of them Code: sConn = "ODBC;DSN=NIKULIVE;UID=user;PWD=password;SERVER=nikulive;" sSQL = "SELECT DSTI_PDS_INFO.PROJECTNO, DSTI_PDS_INFO.DESCRIPTION, DSTI_PDS_INFO.CLIENT, DSTI_PDS_INFO.CLIENTCODE, DSTI_PDS_INFO.STATUS, DSTI_PDS_INFO.FUNDING_CATEGORY, DSTI_PDS_INFO.POINTOFSALE, DSTI_PDS_INFO.BUSINESSSTREAM, DSTI_PDS_INFO.MAP_PFA " sSQL = sSQL & "FROM NIKU.DSTI_PDS_AUDIT

Search Excel Forum Posts, Tutorials, Macros, Tips, and More New Excel Help Service! All Rights Reserved. Excel seems to work fine otherwise. She tried the export on two different machines (Vista and Windows 7) and both create the same error.

Then I checked MAMP > phpMyADMIN to make sure the database is named shirts4mike, which matches the name of the database in inc > config.php. I am using pivot charts so this is important to always have this updated data. Thank you for your help. It's probably something glaringly obvious but I've done this so many times and never had an issue.