Import txt file but cant change data type

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

field size - 13 Sep 2004 04:29 GMT

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 !!

Reply to this Message

'69 Camaro - 14 Sep 2004 03:12 GMT

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.)

> 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
[quoted text clipped - 5 lines]
>
> Need help VERY URGENT. Thanks a lot !!

Reply to this Message