Community archive

Ask something
Discussion Locked

Microsoft Excel and Access

0 helpful
2 replies

by mwilson

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How do I link data from Access into Excel? What I have is customer Miles tracked in access. Each month I bring up a excel spreadsheet which has the date, customer and miles in separate cells. When I enter the customer, I want the spreadsheet to automatically put in the customer's miles, which it would get from the access database. Does anyone know how I can do this or what I need to do this?

2 replies

by redgt302

Have you thought about having Access link to Excel, and get the data you need from Excel, automatically updating based on entries.
This would work better, as linking tables in Access to outside files is easily accomplished.
You could create a form in Access, that could replicate what you are currently doing in Excel.

by cjg2001

You can link cells in Excel to a database file using Microsoft query. In Excel click on the DATA menu command and goto GET NEW DATA - this will give you the option to create a database query which you can then customize in almost any way you can do in an Access query. The help guide in Excel has a good explanation on how to do this.
If you are experienced in Access queries it is fairly simple to use this command.

This discussion is closed to new replies.