Import Problem can't select different fields

[arnie275]

I am having a problem with Access, when I import a text file everything goes fine until I get to the screen after selecting to import into a new table. The one where you can rename the fields and select the data types and choose to skip the field. Here you should be able to select any of the fields and make changes, well when I select another field nothing happens it does not change to that field. See the attached image where field3 is picked but the field options still had field1.

Anyone else come across this or have any suggestions for fixing it? I guess I could reinstall Access but it's an office computer and would require getting our IT staff to do it since I don't have access to the Access install files.

The file will import fine if you go to finish but it loses data because the fields are not set properly for the data being imported, and I could always create a table first but sometimes it's just easier to do it at load time.

Thanks for any help,

 

[Hayley Baxter]

What version of Access are you using?

There is a link here on the microsoft site that might help

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

Hay

 

[arnie275]

What version of Access are you using?

There is a link here on the microsoft site that might help

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

Hay

I am using 2002 and have all the updates for it, the first issue on the hotfix list for 2003 is exactly the problem I am having. I guess I'll try contacting Microsoft and letting them know I have that problem with 2002.

Thanks for the link.