Text Qalifier Problem on Import CSV

  • Thread starter Thread starter gg
  • Start date Start date
G

gg

When I import a csv file that has field with quotes, the Access import Wizard
adds two more quotes on each side. "Jones" becomes """Jones""". When I
show " as the text qualifier, the field reverts back to "Jones" which does me
no good at all as I want Jones without any quotes. I am using Access 2000.
The csv file was created in excel also part of the Office 2000 suite.

I created a text file in Notepad and problem doesn't occur (i.e. "Jones"
becomes just plain Jones when I specify the text qualifier. An earlier
question along these same lines implied that the problem could be from a
source using other than Windows. Not the case here.

Any help much appreciated, i am about to write some cumbersome stuff to hide
the quotes.
 
Strange. I'd be tempted to just import the data as is then use Update queries
with the Replace function to clean up the mess.
 
I tried the replace funtion and got the undefined function message. Is there
something I have to download from the microsoft library to make the functio
work?
 
Through this site and other sites I found that Ac2000, earlier versions, do
not support the replace function, even thought they show it in help. I
suppose one of the several reasons that Ac200 is not the best version to work
with. Through theose same sites, I did find how to write a VBA replace
function that removes the commas. Thanks for giving me the direction to
travel.
 
Actually, Access 2000 does support the Replace function, but there are
certain places (such as in queries) that there can be problems if all
service packs haven't been applied. All you need do, though, is write your
own function that calls the built-in Replace function:

Function MyReplace(InputText As String, FromValue As String, ToValue As
String)

MyReplace = Replace(inputText, FromValue, ToValue)

End Function
 
Back
Top