Import txt file

[Irene]

i have a file which is export from ubs. i'm import the data to my access
system. but when i click import, it will come out a message that is
"Microsoft Office Access was unable to append all the data to the table. why
come out this message? is it because the file from ubs have null data? what
should i do? the file have many field but i just need using certain only. so
can i choose the field i want to use only? hope somebody can help me, thanks!

 

[Jeff Boyce]

Irene

One option would be to "link" to the file, rather than importing it into
Access.

You don't describe the data in the file ... how many fields, what type?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

i have a file which is export from ubs. i'm import the data to my access
system. but when i click import, it will come out a message that is
"Microsoft Office Access was unable to append all the data to the table. why
come out this message? is it because the file from ubs have null data? what
should i do? the file have many field but i just need using certain only. so
can i choose the field i want to use only? hope somebody can help me,

thanks!

 

[Irene]

hi Jeff Boyce,

thanks for your reply. sorry that didnt describe the details for the file. i
need export the file from ubs which is the DO. so when i export the file,
there have 109 fields. but i just need 9 fields. i cant choose the field
which i want to export. i tick the DO to export, then it will come out all
the fields. it is a csv file. i cant use link because the file will export
everyday, due to they want to update the customer's order. if i use the link,
then after the update, i need delete the data, but it is lock. so that i
using import. when i import i was come out that error, but when i click
proceed, then it will automatic create a table which is name "Name
AutoCorrect Save Failures". then inside the table show the failure reason is
"could not save the save the object." why like this? what can i do? thanks!

 

[Jeff Boyce]

Irene

Perhaps I'm not understanding your situation...

It sounds like you have a .csv file. I've successfully linked from an
Access database to a .csv file, replaced the .csv file with another using
the same name, and kept the link from within Access. What happens when you
try to do this?

If your Access database has "Name Autocorrect" turned on, consider turning
it off. In some earlier versions having this feature running caused
problems elsewhere (e.g., with Report Definitions).

Can you provide a bit more information?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Irene]

hi Jeff Boyce,

sorry that my english is poor, and it was make you cant understand what i'm
talking about. i have a csv file which is export from ubs. the csv file is
all contain the delivery order. so i want to use this csv file to update my
outstanding. i cant direct link the csv file to my access cos after the
update, i want to delete the contain of the file. i want to do like this
because i scare the user will accidentally click the button twice, then it
will update duplicate. so that once i finish the update, then access will
open the original csv file and user clear all the content inside the csv
file. so that it wont be happen twice duplicate. if i'm using link the file,
i cant use access direct open the file. this is the purpose i want to do like
this. have any idea? if didn't have any idea, then never mind. i will try to
do other way. anyway, thanks!

 

[Jeff Boyce]

Irene

I don't know what you mean by "user will accidentally click the button
twice"...what button? What code or macro runs when the button is clicked?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Irene]

hi eff Boyce,

Thanks for helping me a lot. feel so sorry that i was make you wasting so
much time. i have found a solution by myself. anyway, thanks!