Jump to content
Sign in to follow this  
amirc

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

Recommended Posts

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 :P i wrote why and not way.**

Edited by amirc

Share this post


Link to post
Share on other sites
amirc

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

ty \:

Share this post


Link to post
Share on other sites
MSLx Fanboy

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


Writing AutoIt scripts since
_DateAdd("d", -2, _NowCalcDate())

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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 by randallc

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.