Linking Excel & Access

  • Thread starter Thread starter Ty Archer
  • Start date Start date
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.
 
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.
 
Back
Top