Importing Text

[Scott]

I recently installed OfficeXP SP-3 and Access no longer imports text files
properly. Every field is set up exactly like the first field would be set
up. Any thoughts on how to fix this?

 

[Ken Snell [MVP]]

Are you using an import specification? More details, please.

 

[Scott]

No, I am not using import specification and very seldom do. It is possible
that I could set it up to do that as a work around but most of the time I
dont need to do that. As I click on Field1 to change the name or whether is
a number field or text field the changes are made but when I click on Field2
they're identical to Field1 and if I change Field 2 it also changes Field 1
and all of the other fields that I want to import. I import text files a
lot and this is going to be a serious problem for me.

 

[Ken Snell [MVP]]

I've not seen reports of this issue for ACCESS 2002 (Office XP); it sounds
similar to a problem in ACCESS 2003 that was fixed by a hotfix
(http://support.microsoft.com/default.aspx?scid=kb;en-us;837003).

Try running a repair of your Office XP setup. There may be a problem with
the text import wizard.

I also would try clicking on the Advanced button and see if you can modify
the fields' information there in the "specification" part of the wizard. As
a troubleshooting issue if nothing else.
--

Ken Snell
<MS ACCESS MVP>

 

[Scott]

Ken, I read the hotfix article and it is very similar to the 2003 problem,
unfortunatley there is no fix for the 2002 version. I also did a repair and
that did not help. I tried using the Advanced button to use the import
specificatins and that WILL work. I'll go that route from now on.

Thanks!

 

[Ken Snell [MVP]]

OK - I'll check with my peers and MS to see if there are other reports of
similar situation with Office XP.

 

[Ken Snell [MVP]]

Which operating system are you using?

 

[Scott]

Windows XP
Office XP 2002

I guess it would be nice to have a fix because I know the layout of most of
the files I import but the ones I dont it will be harder to do with the
advanced button.

 

[Ken Snell [MVP]]

Windows XP, Windows XP SP1, or Windows XP SP2?

 

[Ken Snell [MVP]]

And do you have all the Jet patches up to date too?
--

Ken Snell
<MS ACCESS MVP>

 

[Scott]

Windows XP SP-2, dont know about the jet packages.

 

[Ken Snell [MVP]]

How to obtain the latest service pack for the Microsoft Jet 4.0 Database
Engine
http://support.microsoft.com/default.aspx?scid=kb;en-us;239114
--

Ken Snell
<MS ACCESS MVP>

 

[Ken Snell [MVP]]

Are you using "Classic" theme or "Windows XP" theme?

 

[Scott]

The Start Menu is the classic start menu, is that what you're talking about?

 

[Scott]

This is the version I am using, appears to be up to date: 4.0.8618.0 Security
Bulletin MS04-014

 

[Ken Snell [MVP]]

I'm referring to the theme that is set via this method:
http://support.microsoft.com/default.aspx?scid=kb;en-us;307855

Windows XP Theme has been figured in some problems with access to areas on
screen, and was just wanting to know if it might be related in some way to
what you're seeing. But it seems that you're using the old "classic" type
theme instead.

 

[Ken Snell [MVP]]

I have just been able to reproduce the problem that you note. I had thought
it was working ok for me, but I usually use the Advanced window and hadn't
paid attention much since I installed SP2 of Windows.

OK - I am reporting this to Microsoft as a bug.
--

Ken Snell
<MS ACCESS MVP>

 

[Scott]

You actually reproduced the problem? Freaking Amazing.
Couple of more questions for you....
1. Do you get paid for all of this?
2. How in the world do you keep track of posts that you've replied to?
3. How will I found out about a fix asuming they come out with one?

 

[Ken Snell [MVP]]

You actually reproduced the problem? Freaking Amazing.
Couple of more questions for you....

1. Do you get paid for all of this?

No, there is no pay for this volunteer work. See
for information about the MVPs.

2. How in the world do you keep track of posts that you've replied to?

I use Outlook Express and set the Watch Messages flag on posts that I've
answered; I then sort these to the top of my ng messages so that I can scan
them quickly.

3. How will I found out about a fix asuming they come out with one?

I have submitted the bug via the MS person who manages the MVP program. I
should hear back from her with some information regarding (1) is it a bug;
(2) is it a bug that MS will fix in an "old" technology; (3) if it will be
fixed, how might that occur and when.

I can post back in this thread if I hear an answer within a few weeks. If it
takes longer than that, I can send you an email if you will provide me with
your email address. Send me an email (remove this is not real from my email
reply address) and I'll hang onto it for when I get some info.

 

[Ken Snell [MVP]]

I received the following information from Microsoft about this problem.

That's a known issue of ACc2002 SP3. There is a Hotfix available for this
problem. Description of the Access 2002 post-Service Pack 3 hotfix package:
May 27, 2004 (841365)
http://support.microsoft.com/default.aspx?scid=KB;EN-US;841365



--

Ken Snell
<MS ACCESS MVP>