Importing data from an ODBC database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to import data from an Oracle database into Access, but I cannot find
a way of restricting what data I want to be returned to Access, ie a data
range of financial year paramater. At the moment I get all seven financial
years instead of just the one I need. Any advice would be appreciated.

cheers
 
I want to import data from an Oracle database into Access, but I cannot find
a way of restricting what data I want to be returned to Access, ie a data
range of financial year paramater. At the moment I get all seven financial
years instead of just the one I need. Any advice would be appreciated.

cheers
Click to expand...

my guess would be to create a stored procedure that accepts
parameters, open an ADO connection to the oracle DB, and then return
the recordset to your front end... but then what do I know?
 
I can broadly understand what you suggesting but how does it work in
practise. I do know a little of VBA but I take it, it requires a script to
be written for it to work.
cheers
 
neil said:
I can broadly understand what you suggesting but how does it work in
practise. I do know a little of VBA but I take it, it requires a
script to be written for it to work.
cheers
Click to expand...

AFAIK none of the import options allow you to filter the data. Instead of
importing LINK to the ODBC table and then use an append query to copy the data
from the link to the destination table. The append query can select just the
records you want.
 
You can write and save a query in your Access database. Then go to
tables/import data pick Access as the datasource, chose the database you are
already using, click on the query tab, select your query, click on the
options button and pick "import query as a table" and then import it..
 
Back
Top