Merging Access Query with Excel Form (1 Viewer)

ssworthi

Registered User.
Local time
Today, 08:32
Joined
Jun 9, 2010
Messages
97
I have been tasked to merge query results with an Excel for; there are not too many fields, two emp # and name. How would I do that; I'm under the gun for time (of course) but thought I'd ask the experts before I try to figure this out. Thanks in advance,
 

JHB

Have been here a while
Local time
Today, 17:32
Joined
Jun 17, 2012
Messages
7,732
Which query do you have. How and where do you want the result showed?
 

MSAccessRookie

AWF VIP
Local time
Today, 11:32
Joined
May 2, 2008
Messages
3,428
MS Access has the ability to view an unformatted Spreadsheet as a Datasheet. If you use Access to create a Link to the Excel File, Access can treat the Spreadhseet as a Read-Only Table, and you can proceed from there.
 

Users who are viewing this thread

Top Bottom