Delimited Text to 10 seperate columns in Query

[memaxt]

Hi everyone,

I'm trying to build a query that can parse Delimited text to columns,

for example I have the following:

ID,Name,Tel,Fax,Email,Directorate,DOB,AOCD,Reg,CD



I would like to convert the above in 10 seperate columnns within a query?

Is this possible? I know you can import delimited text to columns but that is not what i'm after for other reasons.

Many thanks
Max

[Bob Fitz]

Cross-posted: http://www.access-programmers.co.uk/...d.php?t=268882

Please read: http://www.excelguru.ca/content.php?...-cross-posters

[ItsMe]

You could use the split function in conjunction with an array.

[memaxt]

You could use the split function in conjunction with an array.

May I ask on how you would do that? apologies as i'm really struggling

[ItsMe]

LMGTFY "vba split function array"

http://msdn.microsoft.com/en-us/libr...(v=vs.90).aspx
and
http://support.microsoft.com/kb/266289