Reading values in CSV text inside a query (1 Viewer)

TomLoder

New member
Local time
Today, 19:30
Joined
May 21, 2013
Messages
5
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

Super Moderator
Staff member
Local time
Today, 19:30
Joined
Feb 19, 2013
Messages
16,553
don't think you can do it - why not just create a linked table to the csv file or use transfertext or textstream?
 

Users who are viewing this thread

Top Bottom