Quote:
Originally Posted by unboggling
Great, thanks. Now I'm off to try a build from the ODBCdriver source code.
|
Another way to do this... not sure how you would do in Mac but in Windows a lot of times I will have text or csv dumps that I need to query.
1st. I start a new Access database and link to the text(csv) file, you only have to do this once since every time the file is changed it is pointed to since you are linking and not importing (set up a folder so they are in the same place so you can keep track of)
2nd. In Excel set up a data connetion to that Access database, then you can run any query anytime you want on it, as far as Excel is concerned it is a database