Recent content by eaglesparadise

Hi Guys, I have used two excel sheets which Im inporting to access and then transpose those sheets using a query. Later I merge both the sheets into to one. Now I want to use the first row in the sheet to set as column heading. Can anyone help with do this using a query or maybe an internal...