Cant Modify Field Options Using Import Wizard?
I'm importing from an Excel 2003 spreadsheet into Access 2003. The import wizard will not let me change any column names or column properties. When I get to the Field Options screen, no matter which column I highlight, only the first column properties will change.
Is this a bug in Access?? IIRC, this worked fine in Office Pro 97, I remember doing it and doing it correctly quite often. Now it will not work, neither in Office XP nor in Office 2003. It doesn't matter if I am at home or at the office, it doesn't work.
What's the deal?? If it isn't a bug, then how do I fix it so I can use it again?? What am I missing?