A
Anna
Hello,
I have Access 97 application that imports coma delimited
file into Access table using TransferText action. This
worked fine on Windows NT workstation.
Now I try to run this application on Windows 2000 system
(Access 97 or 2000 both have the problem) and this action
doesn't work. It simply doen't recognize the coma as
delimiter. For example, I have 2 fields (F1 and F2) in
text file and 1 record of data:
F1, F2
Data1, Data2
When TransferText action tries to import it to the table
that has 2 fields: F1 and F2 I get error meesage:
Field 'F1, F2' doesn't exist in destination table.
(Error number: 2391) It doesn't recognize the coma !!!
I tryed the same on Windows XP machine - works.
May be someone had the same problem and knows how to deal
with it.
I appreciate your help.
I have Access 97 application that imports coma delimited
file into Access table using TransferText action. This
worked fine on Windows NT workstation.
Now I try to run this application on Windows 2000 system
(Access 97 or 2000 both have the problem) and this action
doesn't work. It simply doen't recognize the coma as
delimiter. For example, I have 2 fields (F1 and F2) in
text file and 1 record of data:
F1, F2
Data1, Data2
When TransferText action tries to import it to the table
that has 2 fields: F1 and F2 I get error meesage:
Field 'F1, F2' doesn't exist in destination table.
(Error number: 2391) It doesn't recognize the coma !!!
I tryed the same on Windows XP machine - works.
May be someone had the same problem and knows how to deal
with it.
I appreciate your help.