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:
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: