ansaurus

Question

Answer 1

A:

Do you wish to use Excel data in Access? If so, simply link the spreadsheet (External Data).

EDIT
You can also link tables from other Access databases to easily create queries in the Query Design Window.

DAO is native for Access, here are a few notes:

Dim db As Database
Dim rs As DAO.Recordset

Set db = OpenCurrentDatabase("c:\docs\MyDb.mdb")
Set rs= db.OpenRecordset("Select Field From Table")

db.Execute "Update Table Set Field=2", dbFailOnError

Remou 2010-01-28 14:57:39

I would prefer to just set up the query in Access. I need to compare the data to other data to make specialized reports. I want to skip the Excel step if possible.

David Glick 2010-01-28 15:02:08

Answer 2

A:

Is your Access file your database or do you want to query another database from Access?

Morten Anderson 2010-01-28 14:58:12

The Access file is my database; the database I am querying is not. It is a homegrown database for my company.

David Glick 2010-01-28 15:00:57

You should link the tables from your company database into Access. Then you will be able to query them from Access.this link might help you - > http://www.techonthenet.com/access/tables/link_table2007.php

Morten Anderson 2010-01-28 15:07:27

Unfortunately I don't have direct access to the tables - I would only have access to them through the database connection. I can't see them on the company network.

David Glick 2010-01-28 15:21:23

"through the database connection" -- meaningless phrase. Please explain what you mean by it.

David-W-Fenton 2010-01-28 19:17:44

Answer 3

A:

I don't have MSAccess installed on this machine, so I might have the menu names incorrect.

If I understand correctly you're just trying to get MSAccess to connect to an ODBC database.

Go to the Main menu. Select "File"/"External Data"/"Link" ...

A wizard will step you through the connection set-up and show you the tables available in the database you're connecting to.

Once you've selected all the tables you want to work with, Access imports the definitions and they behave mostly like the local tables.

also see

http://www.aspfree.com/c/a/Microsoft-Access/Importing-Data-into-MS-Access-with-ODBC/1/

Loopo 2010-02-02 20:47:17

ansaurus

tags:

views:

answers:

Connect to ODBC from Access (Newbie)

related questions