Yes, you will need to select your required option, depending on how the data is arranged on the spreadsheet.
Sorry I mean that on my desktop the ability to set the option does not come up MS Access just loads the excel file and the first row goes in as data.
It also does not give me the option to change the column attributes on my desktop as does my laptop.. Was there a problem with the installation?
Could you send me a screenshot of the options where they do show for you on the laptop?
After I select the excel file and the screen comes up to select the sheet the inport wizard just loads the file. No other options.