Problems with Import Spreadsheet Wizard

[Conan Kelly]

Hello All,

Every time I go to import data, the Import Wizard doesn't appear to be
functioning correctly. When I get to the "You can specify info about
each of the fields..." step, the Field Options section shows info
about the first field. But when I click on other fields to change
them, the info shown in the Field Options section doesn't update to
reflect the current field. This isn't a huge problem. The data will
still import. But if I want to make changes, I have to go into the


table afterward and make them there.

Has anyone seen this before? Do you know how to fix it?

Thanks for any help anyone can provide,

Conan Kelly

[minormark]

I had this today too - found this fix on MS website (for Access 2003):

http://support.microsoft.com/?scid=k...509&sid=global

and this old workaround still works if it's a text/number problem: (this is what i used as our network administrators may take years to consider the MS fix):

Create a macro in Microsoft Excel that contains the following procedure:Sub Addspace()

Dim cell As Object

For Each cell In Selection
cell.Value = " " & cell.Value
cell.Value = Right(cell.Value, Len(cell.Value) - 1)
Next

End Sub


4. Highlight the cells in the spreadsheet that contain the mixed data.
5. Run the macro, and then save the spreadsheet.

these should now link as text fields properly.

That is from:

http://www.computing.net/office/wwwb...469.html<br />