Import txt file but cant change data type

[Guest]

Previously i import txt file and change the field name + the field data type
using the import wizard. But after i have update the office with service
pack3 i face difficulties!! As usual i import the txt file but i can only
change the FIRST field name + field data type, the other fields CAN'T change
name nor data type!! Then i try to import the txt file without changing the
data type in the import wizard, but because of the records is 150,000++
therefore i cant change the field data type after imported the txt file.

Need help VERY URGENT. Thanks a lot !!

 

['69 Camaro]

There's an Access 2002 post-Service Pack 3 hotfix available, but you'll have
to contact Microsoft's Product Support Services to get it. Check out the KB
article about the hotfix here:

http://support.microsoft.com/default.aspx?kbid=841365

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)