linking to an excel table

Hi there,

I have a table in excel that i want to link to a table in sql, a gl account table.

The table in excel is a table with GL groupings with two fields, GLGroupingID and GLAccount
GroupingID GLAccount
1000 40000
1000 40100
1000 40200
2000 40400
2000 40500
… …

The GLAccount field will be the field to link to the sql table.

Ultimately, I need a grouping by the GroupingID and list all the GLAccounts and their attributes in my report. Any idea how to do this?

thanks!