Graphics

Does anyone know how to code a CSV file in DataLinq properties to read a specific row based on a DataLinq key? Example: I pull in team stats based on there Team Code in an XML file. I would like to be able to use that same code pull in the team logo as well. Currently in my CSV file I have all of the Team Codes in Column 1 and the Image path in Column 2. Anyone have any thoughts?

17 months later.... how does one format a query for datalinq CSV file? What is the source ("FROM ____")?


#XPression

The issue, in my case, is the data comes in from another service. The data can be converted, with some annoyance, to Excel or something else, but then it has to be done on a daily basis.

We actually worked around this by writing a script to read the file and parse through it to get the data we want. Using datalinq would be cleaner and conform more to how things are normally done (i.e. we don't like special cases if they can be avoided).

So I still think it's a valid question... I understand this is probably more of a Microsoft issue than Ross, but if there was some default table name for CSV data so that you could issue a query, that would be really convenient. What I've seen in the past is the filename being used for the table name, but that didn't seem to work for us. (for example, "foo123.csv" => select from foo123 where ).

#XPression