SQL Server

[Guest]

Hopefully this is a simple one.

I am wanting to set up a link to our manufacturing database using Access.

I have been able to establish an ODBC link through start> Control Panel ->
Admin Tools -> Data Source (ODBC) from this I have been able to import the
information into Excel, but do not know have to do this through Access.
Previously this as been set up by the IT department, but at my new company
they do not exsist!!

Can anyone help?

Much Appreciated

 

[John W. Vinson]

Hopefully this is a simple one.

I am wanting to set up a link to our manufacturing database using Access.

I have been able to establish an ODBC link through start> Control Panel ->
Admin Tools -> Data Source (ODBC) from this I have been able to import the
information into Excel, but do not know have to do this through Access.
Previously this as been set up by the IT department, but at my new company
they do not exsist!!

Can anyone help?

Open Access; create a new database, if you don't already have one. An
Access Database is not like an Excel spreadsheet; instead it's a
container for multiple tables, forms, reports, code and other objects.

When you have your database use File... Get External Data... Import on
the Menu to import data from a SQL table into a local Access table; it
will make a separate copy of the data. It may also be appropriate to
use File... Get External Data... Link to generate a "hot link" to the
SQL data; this will show the current data in the SQL table, and any
updates you make to the linked table will be made in the actual SQL
table.


John W. Vinson [MVP]