Excel files as Data Sources

[dar100111]

Hey All,

I was wondering if someone could help point me in the right direction here.

Could I keep a few CSV files and have them act as datasources or tables to write some SQL queries to handle in my scripts.

I wanted to keep it simple and keep a few Excel CSV files with some information that our users at work can update easily.

My goal is to build some pricing and updating features into some scripts I am going to write for different customers so I need to bounce it off of something.

I want to make this plug an play and still be quick for some other offices within my company.  So I wanted to avoid just setting up a database for it, because

information can change week to week and it will be managed by departments for specific customers.

Would SQL lite be something I can use for this?  I'm trying to look at the most efficient way to do this without reading all the excel sheets to arrays because

that can take quite a bit of time.

A bit new to programming but have some DB2 sql knowledge and scripting experience so any ideas or help greatly appreciated!

Thanks!

 

[water]

You can use ADO to access CSV or Excel files as data sources. I suggest to use Excel files because it is easier if you manually need to modify them.

[dar100111]

Thanks Water!  ActiveX Data Objects I'm assuming, and can I program directly into the scripts?  Wasn't sure if I can set variables using SQL like structure or if it's just completely different.

I'll take your word for it though and start trying to find out as much information on the net as I can.

[water]

With the correct provider you can access a CSV, Excel or whatever like a MySQL database.

I started to describe ADO & AutoIt in the Wiki (still work in progress).

In the forum you will a few examples describing how to access Excel using ADO.

[dar100111]

Thank you very much water!

[water]