You can import manually through File | Get External Data | Import on the
menu, or you can do it programmatically using the TransferSpreadshet method
of the DoCmd object.
Once the data's in Access, you make a report the same as for any other data.
Sorry for such a non-specific answer, but you didn't give many details in
your question!