excel_oracle (page 6) Questionssubmit your own question

I am running Oracle 10g on an Windows XP system. How do I access data in a MS-eXcel spreadsheet from SQLPlus? I have set up the eXcel ODBC Driver. What does the following SQL Server code translate

Can we get data from table feature of Excel 2007 / 2010? Ex. Select * from Table1 or Table 6, instead of select * from [Sheet1$]

Hello everyone! I have a big problem :) How can I export an Excel spreadsheet (only a single worksheet) to a remote MySQL database using VBA code? I have always imported a .csv file with phpmyadmin, b

I'm working in Visual Studio. I have created a OleDbConnection object that i need to assign a string to. From what i gather, i think i should use this one: Provider=msdaora;Data Source=MyOracleDB;User

What is the function within Excel to call a textfile in the same folder, and search within textfile for a keyword? Websites considered: http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/

Hi, I've installed a Windows Server 2008, with Oracle 10g client... The old provider in my ".asp" page doesn't work (Windows Server 2003 + Oracle 9i client): conn.open "Provider=MSDAORA;Data

When I run sql (select count(*) from table_name from xlsx file I result is 65535, but the excel sheet have more that 65535 rows. How fix it? Connection string is : "Provider=Microsoft.ACE.OLEDB.12.0

Hi all, i hope i'll be clear to explain... I've an .xlsx file with 339 columns (used for import a wide range of data) but if i ask ADO to tell me how many columns (to check data integrity) i only ge

I want to create a DataSet from an excel without knowing the name(s) of the sheets inside. Is it possible to get the names of the sheets using OLE DB Provider ? So a I can perform several SELECT orde

Hi! I’m accessing an Oracle database via Oracle Provider for OLE DB 11g Release 1 (11.1.0.7.20) using Delphi (several versions). The program works as expected, opening tables and displaying info

I am trying to utilze excel vba to connect to a microsoft access database that is linked to oracle tables at work. I have been able to do this by saving my password in access for the oracle linked ta

I am trying to make ODBC connection using: 1. Primavera SDK 2. XE in Oracle 3. Microsoft for Oracle but always connection failed. I have windows 7 Ultimate x64 and Primavera P6 V7 with

There is some way to limit the number of returned rows?

Hi I learnt from connectionstrings.com that "HDR=Yes" in Connection String for Excel indicates that 1st row is not values but Column Names. I have a requirement where I need to consider 2nd row

I am using asp.net to create a project and i need a connection string to connect it with an Oracle server which is on a LAN network. I know its IP address, and port number I will arrange if required.

I created my connection string in Dreamweaver MX as shown below: <% ' FileName="Connection_ado_conn_string.htm" ' Type="ADO" ' DesigntimeType="ADO" ' HTTP="false" ' Catalog="" ' Schema="" D

I'm looking over the Excel examples and see a problem: what if I don't know the exact name of the Excel file I'm trying to open? All of the examples need a full name either in the Dbq or the Data Sour