Linking Excel & Access

T

Ty Archer

I have 12 excel spreadsheets with totals in about 10
columns, I wish to link these totals to records in an
access table. Is this possible, and if so what is the best
way of doing it. Thank you very much for your kind
response.
 
K

Ken Snell

By "link", do you mean you want those totals to show as a field along with
fields from a table? If yes, you can link to those spreadsheets as "linked"
tables, and then write a query that includes the desired "column" from EXCEL
sheet as a field in the query that includes the fields from the other
tables.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update several ppt documents from a single excel file 0
Autonumber field in Excel that behaves the same as Access 0
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Need Help with Macro Security 1
New computer, how do i move outlook 365 ENTIRELY? 0
Linking data in MS Word into Excel 5
Embed the same Excel multiple times 0
Excel does not accept text format! 0

Top