Importing excel file into Access using Macro

I am able to import a file from excel to access manually, using the top row as my headings, successfully. however, when using the TransferSpreadsheet command in a macro, importing, excel 5-7, has field names is YES, the file comes thru with all the alpha heading correct but the last few are years, 1998, 1999 etc and they come thru as F8, F9 etc. (however they come thru fine when I import manually)

HELP!

re: Importing excel file into Access using Macro

Heya, Christie. Welcome to TSDN!

I'm going to go ahead and move this thread to the Access forum, where our resident Experts will be better able to help you out.