Specific range in Excel to be displayed in a form

[ScottBeatty]

Hello,

I have a spreadsheet that my company uses that has about 20 clients presented in a single sheet in Excel so I was wondering if it was possible to display only a selected range (i.e. only one client) in a specific form in Access to cleanse this up a bit.

Thanks,
Scott.

 

[James Dudden]

If the Excel file is linked to the database as a table then you can create a recordset based on the table and add any filters etc there.

 

[ScottBeatty]

Okay thank you