is ther any why to do SQL commands on CSV file?

[amirc]

I have a CSV file (none graphic exel file)

is ther any way to do SQL command as it was mdb file?

ty...

btw csv files goes like that:

1,2,3,4

2,3,4,5

data,data,data,data

r4-c1,r4-c2,r4-c3,r4,c-4

**sorry about the title i wrote why and not way.**

Edited December 27, 2005 by amirc

[amirc]

if its easyer you can tell me how can i use mdb or any other db..

ty \:

[MSLx Fanboy]

You could connect to a database from an ODBC connection, which should allow for everything from text/csv to sql servers

[gurba]

if its easyer you can tell me how can i use mdb or any other db..

ty \:

I would give LogParser a try:

http://www.logparser.com

It's a brilliant tool for parsing most kinds of text/logfiles

[randallc]

Hi,

I have added to my (basic and early) prototype SQLite AutoIt script .

It has the ability to

1. first import a csv file to a database sql file (rename it if you want)

2. Perform a query you write on the table "test"; see it in GUI list view in table "query"

[This could give you examples to write your own, but way off getting a fully fledged udf yet]

See the link in my signature to SQLite first post [my file in last post]; you will need to get Sqlite.exe though to your script directory (but no other files than beta autoit) [read the thread for instructions]

You will see in the thread other options too; but I'm not certain they can query a csv; @piccaso could convert his browser to import, though...

best, Randall

Let me know if want to try it; you may need more detail

Edited December 28, 2005 by randallc