Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

RE: Accessing Microsoft Access Databases

by mdillon (Priest)
on Nov 09, 2000 at 22:12 UTC ( #40759=note: print w/replies, xml ) Need Help??

in reply to Accessing Microsoft Access Databases

when using ODBC to query data from an Access database, tables and "queries" (views in every other database system) are equivalent. you have to write queries in SQL either way.

suppose you have a query called "TotalSales". to get the results through ODBC, you would use this SQL:

SELECT * FROM TotalSales;
you would do the same with a table called "TotalSales".

i'm not sure how the placeholder stuff in DBI interacts with ODBC, since the underlying datasource is potentially quite exotic (though not in the case of Jet/Access).

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://40759]
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others browsing the Monastery: (4)
As of 2023-12-11 18:42 GMT
Find Nodes?
    Voting Booth?
    What's your preferred 'use VERSION' for new CPAN modules in 2023?

    Results (41 votes). Check out past polls.