SQL Query of a *.csv file with >255 variables?

[Thomas]

I am building a query that pulls ~ 225 variables from a dataset that is 800+ variables x 30,000+ observations. I know the Query Wizard won't help me out here, since it limits it's column readings to 255; can I just use the Microsoft Query feature (not the wizard), and type in what columns I'd like via SQL code, and do an extraction? The problem I'm having is that I type in what seems to be good SQL code, but I'm getting errors on it.

Any thoughts on this?

Thanks in advance
- Thomas

 

[Joke]

You might be better off with the SQL.REQUEST( ) function. As far as I understand it now there are three ways to do queries

- MS Query
- SQL.REQUEST
- Programming a Macro

It seems iwth MS Query you have least flexibility and it is rather clumsy because you can't easily change the location of your data base. For SQl.REQUEST you have to install the ODBC addin and then you have access to this function which can be used to get access to all kind of databases including Excel datalists.

Joke

 

[Joke]

You should check out www.bygsoftware.com where Andy Wiggins made a very easy and handy instruccion sheet how to use the SQL.REQUEST( ) funcion.


Joke