View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BT Connect
 
Posts: n/a
Default Problem importing data from Access

When trying to import some data (names and addresses) from an Access
database, the Excel (2003) import wizard shows a "square" character between
the elements of the Street Address data. I presume these are carriage return
and line feed characters of some sort (?)

How can I enter this character in the Other delimiters box to split out the
different elements of the address?

Any other suggestions would be gratefully received!
Jeff