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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

odd non-breaking hyphen behavior 9
Avoid funny hyphenation 4
Fixing Hyphens 2
Issue with Excel 2003 3
dash/hyphen issue 4
Hyphenation in a TOC 9
hyphenation: how to correct the auto-hyphenation of a specific wo 4
Extracting (Copying) Text to the Right of a Hyphen 3

Back
Top