font problem with import text wizard in ACC97

[David Aylott]

Greetings

When I use the import text wizard with a fixed width text file, I add
a break at the correct column but it doesn't line up with the text. It
seems that the display is shown in a non-proportional font.

When I look at the text file in notepad it's all nicely lined up but
in the wizard it's all over the place.

Any ideas on how to fix this?

I'm using Access 97 and Windows 98. Also found the same thing with XP
(I have a dual boot)

Thanks
,-._|\ David Aylott (Author of Access Version Checking utility)
/ Oz \ Email: http://www.aylott.com.au/feedback.htm
\_,--.x/ Shareware, FAQ, hints & tips at:
v http://www.aylott.com.au/

[Michael \(michka\) Kaplan [MS]]

The wizard uses a fixed width font. Is it posible that you have tabs rather
than spaces anywhere in the text?
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.
"David Aylott" <da*****@bigfoo t.com> wrote in message
news:b8******** *************** *********@4ax.c om...

Greetings

When I use the import text wizard with a fixed width text file, I add
a break at the correct column but it doesn't line up with the text. It
seems that the display is shown in a non-proportional font.

When I look at the text file in notepad it's all nicely lined up but
in the wizard it's all over the place.

Any ideas on how to fix this?

I'm using Access 97 and Windows 98. Also found the same thing with XP
(I have a dual boot)

Thanks
,-._|\ David Aylott (Author of Access Version Checking utility)
/ Oz \ Email: http://www.aylott.com.au/feedback.htm
\_,--.x/ Shareware, FAQ, hints & tips at:
v http://www.aylott.com.au/

[David Aylott]

A good suggestion, Michael but the file is definitely OK. I made up a
small test file:

1234 abcdef qwerty
2345 mkoiuyu tyreereer

The breaks do not line up in the wizard.

When I use this test data it's fine:

1234 abcdef qwerty
2345 abcdef qwertyuiop

This makes me think it's using a proprtional font.

Do you know what font it uses - perhaps mine has become
corrupted...???

I tested it with Access 2002 on both files and it's fine.

"Michael \(michka\) Kaplan [MS]" <mi*****@online .microsoft.com> wrote:

The wizard uses a fixed width font. Is it posible that you have tabs rather
than spaces anywhere in the text?

,-._|\ David Aylott (Author of Access Version Checking utility)
/ Oz \ Email: http://www.aylott.com.au/feedback.htm
\_,--.x/ Shareware, FAQ, hints & tips at:
v http://www.aylott.com.au/

[Michael \(michka\) Kaplan [MS]]

If you import as a fixed width text file then the widths will be respected.
Hvae you tried simply doing that?

Ignore the display for now; it would be best first to see if the import
works.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.
"David Aylott" <da*****@bigfoo t.com> wrote in message
news:ji******** *************** *********@4ax.c om...

A good suggestion, Michael but the file is definitely OK. I made up a
small test file:

1234 abcdef qwerty
2345 mkoiuyu tyreereer

The breaks do not line up in the wizard.

When I use this test data it's fine:

1234 abcdef qwerty
2345 abcdef qwertyuiop

This makes me think it's using a proprtional font.

Do you know what font it uses - perhaps mine has become
corrupted...???

I tested it with Access 2002 on both files and it's fine.

"Michael \(michka\) Kaplan [MS]" <mi*****@online .microsoft.com> wrote:

The wizard uses a fixed width font. Is it posible that you have tabs ratherthan spaces anywhere in the text?

,-._|\ David Aylott (Author of Access Version Checking utility)
/ Oz \ Email: http://www.aylott.com.au/feedback.htm
\_,--.x/ Shareware, FAQ, hints & tips at:
v http://www.aylott.com.au/

[David Aylott]

Yes, if I setup the widths manually in the next page and ignore the
display problems it works perfectly. Just makes the process a bit
harder...

"Michael \(michka\) Kaplan [MS]" <mi*****@online .microsoft.com> wrote:

If you import as a fixed width text file then the widths will be respected.
Hvae you tried simply doing that?

Ignore the display for now; it would be best first to see if the import
works.

,-._|\ David Aylott (Author of Access Version Checking utility)
/ Oz \ Email: http://www.aylott.com.au/feedback.htm
\_,--.x/ Shareware, FAQ, hints & tips at:
v http://www.aylott.com.au/

[Dimitri Furman]

On Oct 15 2003, 08:48 am, David Aylott <da*****@bigfoo t.com> wrote in
news:b8******** *************** *********@4ax.c om:

When I use the import text wizard with a fixed width text file, I add
a break at the correct column but it doesn't line up with the text. It
seems that the display is shown in a non-proportional font.

When I look at the text file in notepad it's all nicely lined up but
in the wizard it's all over the place.

I've noticed this too, after installing Access 2002 on the same machine
where Access 97 was installed. Apparently this is caused by the A97 wizard
using the ImexGrid control from ACCWIZ.DLL installed by A2002. If you open
text import wizard in A97, then run Process Explorer from SysInternals,
you'll see that A97 loads ACCWIZ.DLL from Office10 directory.

I suppose one could unregister ACCWIZ.DLL and register whatever library
hosts the old version of ImexGrid prior to running A97, and reverse that
prior to running A2002, but that's not necessarily a wise suggestion.

--
(remove a 9 to reply by email)