Reading values in CSV text inside a query

[TomLoder]

I have a text field that contains a comma delimited list of numbers.

I am trying to read one of these numbers from OLEDB through to an access database.

I am trying to do the following:

SELECT SPLIT(CSVData, ValueNo) as ReturnValue FROM MyCSVDataTable

Where CSVData is a split field containing values like "123,234,345,..." and ValueNo is a value to identify which one i want.

Can anybody recommend a way of achieing this using the standard SQL functions. I am reading the data via OleDB and therefore cannot use a user defined VBA function?

THanks
TOm:banghead:

 

[CJ_London]

don't think you can do it - why not just create a linked table to the csv file or use transfertext or textstream?