Re: Pulling 'current date' data from Oracle into Excel

From: Gerrit-Jan Linker <gjlinker_at_oraxcel.com>
Date: Sun, 10 Nov 2002 16:59:56 +0000 (UTC)
Message-ID: <aqm3ac$cin$10@sparta.btinternet.com>

Yes you can. Consider to use SQL*XL. For one it will pull the data straight back into Excel. Secondly you can automate your actions through Excel macro recording. Finally, to make it fully automatic you can call the recorded macro from Workbook_Open. Let me know if you need a hand with this.

SQL*XL specialises in dealing with databases from MS Excel. It works with all databases and has been tested to work fine against Oracle, Access, Foxpro, SQL Server, Sybase, etc etc

SQL*XL is full featured. You can use Excel cells in the SQL, it supports macro recording, VBA coding, scripting, comes with an installer/uninstaller and has a help system.

Find SQL*XL at www.oraxcel.com

I suggest you download both SQL*XL3 and SQL*XL ADO

Kind regards, Gerrit-Jan Linker Received on Sun Nov 10 2002 - 10:59:56 CST