access_excel (page 5) Questionssubmit your own question

I have setup a Word 2013 macro to fill a combobox from an iseries (HTE-sun) data-source, the query works from excel and fills the spreadsheet - macro works fine.

Pls everyone am using vb.net2010 to design a database application using Access db as my back end, i have connected successfully and my record are inserting fine but my problem is publishing the application

I was trying to read data from excel2010 which is "intermixed" data format in each cell to matlab workspace using below command: connString = 'Provider=Microsoft.ACE.OLEDB.12.0;';

Hi, I 'm making a connection from VSExpress 2012 with a database of Access 2013 and the following error message: " Microsoft.ACE.OLECB.12.0 ' provider is not registered locally on the machine" . How I can fix it? "

How can I connect rumba through excel. I want to extract data from Rumba to Excel. I have code the extract deatils from IBM mainframe to Excel.But I believe the codes should be different for rumba.

Hello, I am using Microsoft.ACE.OLEDB.12.0 with a 32-bit C# application on a 64-bit PC and an Access 2007 backend. The connection string works fine, however depending on where the database is located

I was using Ole db connection to connect the excel.Then Read the data & display on it on screen and then save it to database after validation. But now excel is not getting connected via Ole db connection,as it is encrypted by some other program.

I have an aspx web page that connects to an Access database through an ASP.NET connection string. The code works perfectly when I preview the page on my local machine. But I get this error when I publish the web site to a Windows server at my hosting company:

I have a problem that I don't understand. I have two VS 2008 programs one gives me a Crystal Report just the way it should work. connection string in App.Config "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\QBData\racklist.accdb"

I have used connection string as below in my VB macro. ConnectionString="Data Source=(DESCRIPTION = (ADDRESS=(PROTOCOL=TCP)(HOST=servername)(PORT=portno))(CONNECTDATA=(SERVICENAME=servicename))));uid=username;pwd=password;"

I have created an app in VB 2012 and cannot connect to the database. the error: 'Microsoft.ACE.OLECB.12.0' provider is not registered on the local machine. I am using Access 2013

I am trying to connect to sql server 2008 r2 from Excel 2010 (VBA). the process is for internal purposes only. I need to pass an id and password to connect to the db from excel.

I have executed Teradata Queries using VBA within Microsoft ACCESS for years. Now using the same connection string with ACCESS 2013, I receive the Error Message: Run-time error '-2147467259(80004005):

Hi, I am having a problem connecting MS Access and firebird. Access and Firebird are all 32-bit, running on Windows 7 64 bit.

I have establish a connection to a server in Excel 2013, but it is not giving me the option to use parameters. Does the connection string impact the ability for a local parameters to be set?

i working on project using c# and access 2013 , the wrong is : Cannot open database . It may not be a database that your application recognizes, or the file may be corrupt

I am trying to connect XLS file and below is my connection string. Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 12.0 xml;IMEX=1;HDR=Yes;ReadOnly=1;"

Hi, Please help me with the below question i have a vba excel macro developed , i use sql queries and treating each sheet as table develop macros.

I want to import excel data into my database using odbc and in .Net so i used this connection string: OdbcConnection occon = new OdbcConnection ("Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};

Hello, I need help when using a connection string to connect to an access 2007 database within an ASP page. I am using the string "Driver = {Microsoft Access Driver (*.mdb, *.accdb)};Dbq=(path to db);

I have an MS Access 2010 32-bit database that is primarily a front-end. The data is stored in an SQL Server 2008 R2 managed by my company's IT.

Provider can not be found.It may not be properly installed. VB6 service pack 6 is installed. The Programs works on 1 computer, is is copied to 2nd computer won't work. Mike Wright

Dear folks I've just got myself a Windows Server 2012 R2 as web server. I come from a some old 2003 stuff. Now my problem is to get my connection for MS Access 2013 up and running.

Hi, When i was using QTP i was able to connect to Access database using the below connection string "DRIVER{MicrosoftAccessDriver(.mdb,.accdb)}; DBQ=C:\Automation.accdb;Readonly=True"

I am using .NET Framework 4.5,Microsoft Access 2010 64 bit. I've getting an error in asp.net when it is connecting with access. I've also installed 64 bit ACE engine from this link:-

I have problem with my application that working properly at runtime( via visual studio ) and update data grid of windows form .net . But after publish the application and run this then , I am getting following error as shown in image.

I am working on same solution where i need to update connection strings of multiple files in Bulk.But , Its working for MS Excel 2010 and not for Excel 2013. Exception Result : "Exception from HRESULT: 0x800A03EC"

I have created some apps on my home PC using Visual Studio 2008 (C#) and MS Office 2007 (MS Access) as my database. My OS is Windows Vista. Everything is 32 bit.

Is there a provider and connection string that will allow me to connect to Azure SQL via port 443 the way Access App does? Both SQL Native Client and ODBC seem to only use 1433 which is blocked by my corporate firewall.

Dear All, Thanks for your support in advance :) I am looking to move an Excel Data Base to Access in order to improve efficiency and bring security to the data hold. The problem that I am stacked is related with the loading.