Suman
Oct 30th, 2000, 12:10 PM
I have a Critical and Severe Problem in an Arabic Enabled PC..
I have a Text Database(folder) where I have all the Text tables(files) . I want to insert the Data in the Text File into an Access 97 database which has same structure . And in English Windows Pc's I use the Code Snippet:
(I have only written the SQL here)
"Insert INTO MyTable & _
" Select * FROM [TEXT;DATABASE=E:\D999;uid=admin;pwd=;].[MyTable.txt] "
And it Works Smoothly and its Very Fast too....
But when I use this in an Arabic Enabled PC , Its Failing ...
And when I looked into the Cause , I found that inside the Text File the double quotes which normally enclose Charachter fields in a text database are not coming properly .. I mean the first field if its a characher the doublequotes is coming in the end of the line instead of the beginning ..
I dont know How to solve this Problem . Is there any body out there who has soved this problem ???
I would appreciate Ur help ...Pls ..
I have a Text Database(folder) where I have all the Text tables(files) . I want to insert the Data in the Text File into an Access 97 database which has same structure . And in English Windows Pc's I use the Code Snippet:
(I have only written the SQL here)
"Insert INTO MyTable & _
" Select * FROM [TEXT;DATABASE=E:\D999;uid=admin;pwd=;].[MyTable.txt] "
And it Works Smoothly and its Very Fast too....
But when I use this in an Arabic Enabled PC , Its Failing ...
And when I looked into the Cause , I found that inside the Text File the double quotes which normally enclose Charachter fields in a text database are not coming properly .. I mean the first field if its a characher the doublequotes is coming in the end of the line instead of the beginning ..
I dont know How to solve this Problem . Is there any body out there who has soved this problem ???
I would appreciate Ur help ...Pls ..