Sign in to follow this  
Followers 0
amirc

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

5 posts in this topic

#1 ·  Posted (edited)

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



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

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

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

#5 ·  Posted (edited)

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  
Followers 0