link exported information

[Need Help]

How can I link information I export from access to excel. All the
information I can find refers to information imported from excel to access.

 

[Frank Stone]

hi,
on the access toolbar goto
File>get external date > link tables
a find dialog box will appear.
set Files of Type = microsoft excel
Note: when linking excel files it is ofter good to link to
excel range names rather than the whole sheet.
regards
Frank

 

[Jamie Collins]

How can I link information I export from access to excel. All the
information I can find refers to information imported from excel to access.

By 'link' do you mean 'join'?

To export:

SELECT
MyKeyCol AS MyXLKeyCol,
MyDataCol AS MyXLDataCol
INTO
[Excel 8.0;HDR=YES;Database=C:\Tempo\db.xls;].MyXLTable
FROM
MyTable
;

To join to original table:

SELECT
T2.MyXLDataCol
FROM
MyTable T1
INNER JOIN
[Excel 8.0;HDR=YES;Database=C:\Tempo\db.xls;].MyXLTable T2
ON
T1.MyKeyCol = T2.MyXLKeyCol
;

Jamie.

--