Importing Hyphens

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I import data that includes a hyphen (example MKT-CONSUMER) I now get a
longer symbol (MKT—CONSUMER). Because of this, none of my queries will work
unless I paste in the criteris so I get the longer — instead of -.

See the difference? I've noticed in in Excel 2003 also.
 
This doesn't happen when I try. Can you give more details? In
particular:

What are you importing from?

What character set?

Are you using the same font to view the source data and the imported
data?

What are the ANSI and Unicode values of the character you see as a
hyphen in the source data? You can get these by using the Asc() and
AscW() functions.

What are the ANSI and Unicode values of the "hyphen" character when
imported into Access?




On Mon, 10 Apr 2006 11:35:01 -0700, Good Intentions <Good
 
Back
Top