Access Database

[firsrate_caduser]

Hello every one!! I have a project for the company that I am working for, and I don't even know if it this is possible. A little info:

We are using a Database from our customers in excell format wich we can use as master database and most of our work is getting information from this file. such as nametag, register, desc1, desc2, desc3...etc. so here is my goal.

We are using Autocad Electric 2006, which can be link to ACCES, I dont how but it does, I can import/export information from attributes from several block in a drawing or a whole project from excel files, and other goodies...anyways! my goal is to link drawings (maybe projects) to this master database, so if there is any changes i can do it in the acces file and be able update drawings or other files linked to this master database. Is this possible?

I know is to much to ask but if someone can help me, it will be greatly appreciate.

p.s.
nametags are unique.

[ASMI]

Is this possible?

Yes of course.

[Alan Cullen]

And ASMI is just the bloke to show you how to do it.....

[ASMI]

And ASMI is just the bloke to show you how to do it...

Of course not...

[Alan Cullen]

You'll get used to ASMI's sense of humour after a little while.....

ASMI.....nice play on words, there, mate......

[borgunit]

Here is an example connection to a db, extract the info, and close it back up:

Private Const cnMatlDataSrc As String = "M:\Library\Data\MATERIAL_TRANSLATION.mdb"
Private Const cnString As String = "Microsoft.Jet.OLEDB.4.0"

Public Sub GetMatlDb()
'------------------------------------------------------------------------------
'
'
'------------------------------------------------------------------------------
Dim AdoConn As ADODB.Connection
Dim AdoRecSet As ADODB.Recordset
'''''''''''''''''''''''''''''''''''''''
On Error GoTo ErrHandler

'Set connection to to a new Connection object
Set AdoConn = New ADODB.Connection
'Set the provider of the connection to Jet
AdoConn.Provider = cnString

'Open a connection to the database
AdoConn.Open cnMatlDataSrc

'Initiate a new recordset object
Set AdoRecSet = New ADODB.Recordset

'Open table USING SQL TO QUERY DATABASE
AdoRecSet.Open "SELECT * FROM MATL_CROSSREF", AdoConn
gvMatlArray = AdoRecSet.GetRows '<< FILLING UP GLOBAL VARIANT VARIABLE WITH INFO

ExitHere:
AdoRecSet.Close
Set AdoRecSet = Nothing
AdoConn.Close
Set AdoConn = Nothing
Exit Sub

ErrHandler:
MsgBox "An error occurred. The error number is " & Err.Number & _
" and the description is " & Err.Description
Err.Clear
GoTo ExitHere
End Sub

[firsrate_caduser]

hello everyone!! thanks for all the input!!

ASMI can you tell how it would be done?


thanksfor the info!!