Can't change column names when importing a text file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kris - 27 Jul 2005 20:23 GMT

When I import a text file in Access 2003 using Windows XP, I can't change the
field names in step 4 of the Import Text Wizard. I can change the first
column but when I try to click on the second column or third column, the
"Field Options" at the top won't change. The only workaround I've noticed is
to click on "Advanced" and change the field names there. I didn't have this
problem in Access 2003 using Windows 2000. Any ideas?

Reply to this Message

Ken Snell [MVP] - 27 Jul 2005 23:17 GMT

This is a known issue for ACCESS 2002 SP3. This issue is described in
http://support.microsoft.com/default.aspx?scid=kb;en-us;875252

There is a Hotfix available from Microsoft Technical Support for this
problem. Description of the Access 2002 post-Service Pack 3 hotfix package:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;841365

There also is a HotFix for ACCESS 2003 SP1 for similar issue.
Description of the Access 2003 hotfix package:
http://support.microsoft.com/default.aspx?scid=kb;en-us;837003

Signature

Ken Snell
<MS ACCESS MVP>

> When I import a text file in Access 2003 using Windows XP, I can't change
> the
[quoted text clipped - 5 lines]
> this
> problem in Access 2003 using Windows 2000. Any ideas?

Reply to this Message

richmich@gmail.com - 28 Jul 2005 15:27 GMT

I tried to E-Mail Microsoft on this issue and got this reponse. What
should I do next, seems the outsource center has no clue about
Microsoft products.

The response:

Hello Richard,

Thank you for contacting Microsoft Online Customer Service.

I understand from your e-mail that you wish to have the hotfix for KB
841365. I realize the importance of your issue.

Richard, as a Customer Service Representative, I can assist you with
the support options available with your Microsoft product. However, I
have searched Microsoft resources and found that the supported hotfix
for SP3 is no longer available. Microsoft has released the Service Pack
4 for Access 2002 and it came with the built-in fix for this issue.

If you wish to purchase any of the Microsoft product, please contact
the Microsoft Sales and Information number at (800) 426-9400; Monday
through Friday from 6:00 A.M. to 6:00 P.M. (Pacific Time)

You may also contact our Support Professionals at (800) 936 5700,
during Monday - Friday, 5:00 A.M. - 9:00 P.M. Pacific time and
Saturday - Sunday, 6:00 A.M. - 3:00 P.M. Pacific time.

Richard, In the future, if you have any new issues regarding our
products, you are welcome to send and we will respond to you as soon as
possible. It is our pleasure to be of assistance at any time.

Thank you for using Microsoft products and services.

Prasanna
Microsoft Online Customer Service Representative

If you have any feedback about your Online Customer Service experience,
please e-mail my manager Naveen Kolli at managers@microsoft.com

> This is a known issue for ACCESS 2002 SP3. This issue is described in
> http://support.microsoft.com/default.aspx?scid=kb;en-us;875252
[quoted text clipped - 21 lines]
> > this
> > problem in Access 2003 using Windows 2000. Any ideas?

Reply to this Message

Ken Snell [MVP] - 28 Jul 2005 15:49 GMT

Your post said you're using ACCESS 2003... my reply (taken from my archive
of posts) covers both 2002 and 2003. Taken from a little farther down in my
reply:

There also is a HotFix for ACCESS 2003 SP1 for similar issue.
Description of the Access 2003 hotfix package:
http://support.microsoft.com/default.aspx?scid=kb;en-us;837003

Signature

Ken Snell
<MS ACCESS MVP>

>I tried to E-Mail Microsoft on this issue and got this reponse. What
> should I do next, seems the outsource center has no clue about
[quoted text clipped - 65 lines]
>> > this
>> > problem in Access 2003 using Windows 2000. Any ideas?

Reply to this Message

Ken Snell [MVP] - 28 Jul 2005 16:04 GMT

To get 2003 SP1 hotfix, it'll be best if you call the Product Service
Support phone number.... it won't cost money (other than any long-distance
calls) for this hotfix.

Signature

Ken Snell
<MS ACCESS MVP>

> Your post said you're using ACCESS 2003... my reply (taken from my archive
> of posts) covers both 2002 and 2003. Taken from a little farther down in
[quoted text clipped - 74 lines]
>>> > this
>>> > problem in Access 2003 using Windows 2000. Any ideas?

Reply to this Message

Ken Snell [MVP] - 28 Jul 2005 16:03 GMT

By the way, I am unaware of the release of SP4 for Office XP or ACCESS 2002.
I will need to contact MS about this claim.

Signature

Ken Snell
<MS ACCESS MVP>

Reply to this Message

Ken Snell [MVP] - 28 Jul 2005 18:17 GMT

I have checked with Microsoft... there is no SP4 for Office XP nor ACCESS
2002. You were given erroneous information.

Signature

Ken Snell
<MS ACCESS MVP>

Reply to this Message