Pulling data from Access 97 to Excel 97

[kjclark]

I am trying to pull one field from an Access database to my Excel Spreadsheet.

For example: The user enters projects in Access and each project is assigned an ID#, while in the project record, the user needs to go out to an excel file to fill in NPV information.

How do I get the project ID from the Access record to automatically show up in Excel when the user opens the worksheet.

Any help is much appreciated!

Thanks in advance!
Karla

 

[coachdan]

You can create a query. Try opening a new worksheet, go to "Data"/"Get External Data"/"Create New Query". Follow the prompts to your Access database. Once the query is setup, right-click in the data portion of your Excel sheet and choose Refresh and it will automatically update the worksheet with data from the Access database. Hope this what you were looking for.

 

[kjclark]

It worked like a dream! Thanks for the help!