Re: Is it possible to load the excel file by using external table without converting it into csv comma delimited file


gazzag wrote:
Bib Endum wrote:
As usual, this is so condescendant ! Why don't you keep it shut up sometimes
! I don't like VB, I don't like microsoft, but sometimes, it can be useful
to do quick prototyping or to hack something with word or excel.

I think "hack" is the appropriate word. Well done.

hi allz

First of all thanx for all you guys , I tried the OCA for microsoft
excel but lot of missing
and invalidate procedures/function found then i tried the HS service
for getting excel
data ,i have done the connectivity suucefully for MS access before but
getting error when
doing the same with excel , i am getting the following error pleae
help me.


SQL> SELECT * FROM ABC@xxxxxxxxx;
SELECT * FROM ABC@xxxxxxxxx
*
ERROR at line 1:
ORA-00942: table or view does not exist
[Generic Connectivity Using ODBC][Microsoft][ODBC Excel Driver] The
Microsoft
Jet database engine could not find the object 'ABC'. Make sure the
object
exists and that you spell its name and the path name correctly. (SQL
State:
S0002; SQL Code: -1305)
ORA-02063: preceding 2 lines from ACC.WORLD

.

Relevant Pages

  • Re: Why does Access and Excel use different SQL formats?
    ... I have recently done a job for a company that needed to use Microsoft Query ... MsQuery must be another app that Microsoft bought in holis bolis. ... could be that the Excel team never speaks to the Access team. ... Hence the differences with SQL in Access. ...
    (microsoft.public.access.modulesdaovba)
  • Re: ODBC connection to mdb for MacIntosh
    ... You can take the data that is input and use SQL commands to update Microsoft Access tables. ... You will need to learn some visual basic and some SQL, neither of which is trivial, but both subjects are not too difficult to master for most people. ... If you do a Google search in the excel macintosh newsgroup for Access you'll find a lot of information about why there's no Access for Macintosh. ...
    (microsoft.public.mac.otherproducts)
  • Re: Secure OleDb Connection to a Microsoft Excel Workbook
    ... I realise that Excel isn't a database, but I am unable to use Microsoft ... SQL or the like as the users in the organisation do not have ... The only software standard on the machines is Microsoft Word, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: controling the spread of fields in the excel
    ... Dim SQL As String ... DoCmd.TransferSpreadsheet acExport,, qryExportQuery ... Microsoft IT Academy Program Mentor ... I'm trying to find a way to export the data in the form into excel. ...
    (microsoft.public.access.forms)
  • Re: Benefits of upgrading to Excel2003
    ... You probably don't have access to Excel 2002 and excel 2003 so I've ... Key new features in Microsoft Excel ... Web queries to Extensible Markup Language files. ... If you are not using the specific language version of Microsoft Office ...
    (microsoft.public.excel.misc)