PPRuNe Forums - View Single Post - Linking Excel Spreadsheets to an Access Database
Thread: Linking Excel Spreadsheets to an Access Database
View Single Post
Old 8th January 2007 | 10:45
  #2 (permalink)  
stickyb
 
Joined: Feb 2000
Posts: 542
Likes: 0
From: asia
Linking
Should be easy.

Go to File/Get External Data/Link Tables and then change the file type to xls.

Select the spreadsheet, and away you go.

I am using Access 2000, don't know if the menu has changed in later versions
stickyb is offline  
Reply
0