Can't modify Field infomation

[izlopez]

When I import a spreadsheet from Excel I try to modify the Fields on Field
Option, but I can't select the field (column), This is happening on the
"Import Spreadsheet Wizard" dialog box

 

[OfficeDev18 via AccessMonster.com]

Hi, izlopez,

This is the reason I seldom import an Excel spreadsheet directly into the
Access table of my choice. I import - or even just link - the spreadsheet as
is, and then I have an APPEND query to massage the data from the spreadsheet
into my Access table. Also because Excel number formats aren't always the
same as Access numeric data types, and you must change the data type in
order to use it properly.

Sam

 

[izlopez]

Thank you for your respond, but I checked the Knowlegde base and found that
it is a known issue, and it is corrected installing a fix, or the service
pack 1 or 2, I installed SP2, and it was corrected,

Ivette