Replace commas in access db

[mdctsg]

Hello

I have an access db that I can't alter the structure. In one of the tables the fields contain commas. I use a query to pull the info out into a csv. With the commas in the db I get my information spread out because of the commas. I have heard about the replace function in VB but don't know how to use it or call a function. I don't even know how to call a function. I have never worked with this before. If someone has the time could you please help me fix this problem.

My db is called Orders and the table with the commas is called Agent. Please I would appreciate any help in ending this nightmare

Thanks
Bob

 

[vb5prgrmr]

This
[tt]
StringVariable = Replace(StringVariable, ",", " &quot
[/tt]
would replace the commas with a space. I take it you are actually using VBA within Access. If so I don't remember if the replace function is in access I know it not in 97 but it is in 2k.

Good Luck

 

[mdctsg]

My appologies

I am trying to do it thru vb6 since I can't alter the db. I'm using an ado connection

 

[vb5prgrmr]

Ok, Then the above should work for you. Just type Replace and press F1 and help will come up and give you a description.

Good Luck