What does it do? It reads excel spreadsheets, and generates SQL scripts for each row. Simple rules guide the format of XLS file:
1. Spreadsheet name decides the TABLE name.
2. Within each spreadsheet, first row denotes the COLUMNS. By default first column is taken as primary key, unless you mention
3. The Last column denotes action to be performed. (INSERT, UPDATE or DELETE)
How it works?
1. Pick up the excel file. The UI helps you choose the spreadsheets you want to script. Clicking a button generates the SQL scripts and displays in a text area (optionally multi panes for each TABLE).
2. Edit, save as SQL file(s).
Deploy: Single exe and a properties file on Windows 2000 and above (checked on vista .. works!) . Oh, you should have excel or equivalent extentions (eg Microsoft works)
I wrote it initially in Delphi 5. (I recompiled it today on D7, no change required). It uses OLE Automation to connect to MS Excel and read contents. I wrote it for Netkraft, who wanted a pilot for certain client. I went to Netkraft’s office one afternoon, took me about 5/6 hours or so, for the first version. (Never really got paid for that, but got something else going .. different story!)
Later on, I added few other features. As simple it maybe, 4 organizations still use it extensively – two of them in production and support!! So I thought maybe, just maybe, this old outdated thing can be of some use to somebody! :))
Now, where do I upload the source codes?
No comments:
Post a Comment