Query in Access doesn't work in Visual Studio

[Paola]

I have a query that was created in access and it separates
one column into several colmns. It uses the GetCSWord
function to divide the column. Does anyone know what I
could use to do the same thing using transact-sql? The
GetCSWord comes up as not a valid function in visual
studio.

Paola

 

[Van T. Dinh]

The function GetCSWord does not sound like an inbuilt
function in Access / VBA. Could it be a UDF (user-defined
function)?

If it is a UDF, you will need to re-write the function in
T-SQL.

HTH
Van T. Dinh
MVP (Access)