link exported information

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Need Help said:
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.
Click to expand...

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.

--
 
Back
Top