Linked table

[pointe]

So I have a linked table in my new database. Is there a way to automatically
take one column of the linked table (the key) to create a record in a new
table in my current access database?

 

[aaron_kempf]

Linked tables are no longer the reccomended route.

If you want to share information between databases; you really should
move to SQL Server.
With SQL Server-- all database automagically talk to each other when
and where you want them to.

-Aaron

 

[pointe]

For the time being, I must use a linked table because we're downloading from
a Power Campus, another database system that we're migrating from, which only
downloads into excel format. Unfortunately, I'm entirely too unfamiliar with
SQL servers to make this happen.

 

[Stefan Hoffmann]

hi,

So I have a linked table in my new database. Is there a way to automatically
take one column of the linked table (the key) to create a record in a new
table in my current access database?

Please describe "automatically".

You can create an append query using your linked query, e.g. as SQL
statment:

INSERT INTO localTable (keyField, field1,...,fieldN)
SELECT keyField, field1,...,fieldN
FROM linkedTable
WHERE keyField = actualValue


mfG
--> stefan <--