Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rating: Thread Rating: 3 votes, 5.00 average. Display Modes
Old 05-13-2014, 05:27 AM   #1
TomLoder
Newly Registered User
 
Join Date: May 2013
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
TomLoder is on a distinguished road
Reading values in CSV text inside a query

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

TomLoder is offline   Reply With Quote
Old 05-13-2014, 06:06 AM   #2
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,347
Thanks: 40
Thanked 3,670 Times in 3,538 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Reading values in CSV text inside a query

don't think you can do it - why not just create a linked table to the csv file or use transfertext or textstream?
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Reply

Tags
csv , function , oledb , split , sql

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using DLookup inside a user-defined function which is inside a query klar Queries 8 01-03-2012 10:09 PM
combobox reading values iworkonline Forms 3 02-18-2011 05:51 PM
Reading Field Data & using Data inside a Variable smogsy Modules & VBA 1 01-20-2011 08:43 AM
Get a query inside a text field herbertioz Forms 3 01-18-2010 10:50 AM
[SOLVED] If to only DCount a box with values inside alisemail Forms 1 02-01-2005 08:03 AM




All times are GMT -8. The time now is 08:18 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World