Re: Please I need Help!


"Opyuse" <Opyuse@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AE5C98D7-6F86-46B1-AC41-AE3636EDFDD7@xxxxxxxxxxxxxxxx
> Thanks for the reply but do you mean that I can use access to read into my
> ODBC database? How do I do that?
>
> because I thought that I would have to use my application as an
> Intermediary
> and have some sort of code to read from the excel doc into the database my
> application has access to.

odbc is just a method used to connect to a database, it is not a database in
itself. odbc only provides ways for external programs to access a database
using some standard programming methods.

if the underlying database is access then you can use the built in access
data import capabilities to read from excel files. or if they are on the
same machine you can just open each of them and cut/paste your data.


.

Relevant Pages

  • Re: Nameless CREATE
    ... The starting point is either an existing database or one that is ... "Describe" involves issuing an SQLDescribeCol function to ODBC ... essentially much the same as character data type apart from all 8 bits ... ALTER TABLE tablename ADD COLUMN BinaryColumn BINARY ...
    (comp.lang.forth)
  • Re: fields queries and utter disaster
    ... Unfortunately the \c ODBC DATABASE field switch is not supported in Word ... of course supports ODBC connections but Word ... Mac Word Test ... suggests that it should be possible to use query files (cf. .qry/.dqy ...
    (microsoft.public.mac.office.word)
  • Re: [VW 7.3.1] ODBCConnection
    ... I played around with a few combinations on the connection string and ... with a trusted SQL Server connection. ... there are differences for database connects. ... > any database specific odbc drivers. ...
    (comp.lang.smalltalk)
  • Re: Serious Problem with Date in RecordSource
    ... Yes, this is ODBC data, not JET data, so some if the things I suggested ... >> c): Decompile the database. ... Still in the code window, choose Compile from the Debug menu. ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.formscoding)
  • Re: CDatabase, CDaoDatabase
    ... raw ODBC calls ... DAO will outperform ODBC (and so CDatabase) considerably in single user ... There is considerably more to database performance than making quick ...
    (microsoft.public.vc.mfc)