Can't modify Field infomation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
Back
Top