Hello, I would need help on how to create a connection between R and Microsoft Excel. Thank You.
Hi, my name is Marvin and I have little experience in Mysql. I have mysql 5.5 installed with workbench 6.1. I work with vba excel developing small applications, locally I have no problems connecting to databases.
Can I use ADO to open a connection to a shared Excel (Office 365) workbook that resides on SharePoint. I do not want to checkout the work book as Other people are storing information on it.
I have the Oracle Runtime 11g 32 bits and the 12c Runtime 64bits instaled on my system, and i would like to know if is possible to use the 32bits Oracle 11g(188.8.131.52) ODBC driver on my Excel.
Hi, I use a OdbcConnection string to read xls sheet into a data table (VB.net) is there a property I can use to omit formulas (ex. Vlookup) and use the values instead?
I think I'm almost there. Except the update is inserting into sharepoint. Using Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0. See code below. Situation: I'm refreshing in an excel table from a power query a Sharepoint list (Sharepoint server 2016).
Hi, it is working in Excel-32 bit version, but not working in excel-64 bit. I have a linked table in ms-access which is linked to a sql server table, and when I am trying to fetch the data in excel via VBA from ms-access linked table the error message "ODBC connection failed" showing.
Study Guides or Test Sample for the position of Admin asst? I’m testing for administrative Asst in the civil service sector.So I’ve to take a test to MS Word and Excel. and it’s practical to test my abilities.
Hi! I Need make a connection to Adaptive Server Anywhere 8.0 database using Excel 2013+VBA commands, Someone who can help me
I have a project where I have to send data from an Excel spreadsheet to an Oracle database. I have installed the latest Oracle client and the ODBC drivers.
I'm trying to export the data from multiple database from a single server into one excel using VBA code. Please can anyone help.
Hi My system reads Excel data using a database approach. I use the following connection string as this returns extended characters: Provider=Microsoft.ACE.OLEDB.12.0;Data Source='';Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1";
Hello to all participants, must extract an excel sheet data from MySQL once extracted these data excel sheet processed with many functions, the result of that calculation must be stored in MySQL.
Hello All, I am facing one issue like "External table is not in the expected format." with 2013 micro enable excel . when i am trying to open the connection string for reading the excel file i.e oleConn.Open(); .
Drop down lists without arrows. I have a spreadsheet created by someone else, there are multiple cells with drop down lists that can only be seen when right clicking the cell and selecting "drop down list".
I have a template of a packing list I created. I open the template, fill in some weights and do a save as, creating a new unique file. Is there a formula or method that can be used to write the weights to another workbook as well.
Hi, I've got a weird one. I'm new to Sharepoint and connection strings, so please bear with me. I'm connecting an Excel Spreadsheet to a Sharepoint list for RW access.
I am using Excel 2013 and I created an excel data file on a shared drive. I created a connection file (using data connection wizard in excel) to pull that data into a pivot table.
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.
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 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 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;"
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"
Hello guys I was directed to this site as THE place to find information on how to write the connection string I need. I am still quite new at this coding stuff so any help would be appreciated.
I am really needing a solution for this if anyone can help! I am not a programer, but am proficient with Excel, Adobe, Adobe, Livecycle Designer, etc.
Hi, I am starting to work with a file written in excel 97 & access 97 for forecasting, it is fairly involved and does a great job of profiling etc.
I wanna import an excel file to C# and using the guidelines on internet (forums), I installed a 32bit version of access database engine and then "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine"