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?

Okay, not a fix, but a work around:

Transfer the data from Excel to Access into an intermediate table, then use an Append query or VBA to move it from the intermediate table to the final table. I do this usually since I work with disconnected back ends and want finer control over the data in repetitive operations like this.

If you are interested, I can help with the code. Sorry I can't answer your question.

HTH

mmcdonal

Apparently this is only a problem with importing from Excel. It works fine with delimited text.

This is a known issue with Office 2003 and Microsoft has a hotfix available for this issue. Refer to the link below for more information:

http://support.microsoft.com/?id=837003