A query cannot generate a autonumber field. It can show one if it exists in the underlying table it is built upon. So that portion of your question makes little sense.
Perhaps you want your table to have an autonumber primary key. I think you are out of luck there as well if you are intent on keeping this data in Excel. If you were to import the data and keep it in Access, then you could assign that table an autonumber primary key ID upon importation.
