Export from one Access table to multiple new Excel workbooks based on data

[fpcsql]

I have one table containing +-155000 records and I need to split it into +- 4600 different Excel workbooks based on data in one column. (for each different value I require a new workbook)

I assume I should write a procedure in VBA, only I have very limited experience in VBA and would really appreciate clear instructions.

Much appreciated.