Load Excel data sheet to Oracle database

Load Excel data sheet to Oracle database

I am looking for a free tool to load Excel data sheet into Oracle database. I tried oracle sql developer, but it keeps throwing NullPointerException. Any ideas?…


Is there a way to programmatically import ICS into Google Calendar?

I don't see any obvious way to import ICS files into Google Calendar from the API docs here: http://code.google.com/apis/calendar/developers_guide_protocol.html And I'd greatly prefer not to have to…


What are the pitfalls of inserting millions of records into SQL Server from flat file?

I am about to start on a journey writing a windows forms application that will open a txt file that is pipe delimited and about 230 mb in size. This app will then insert this data into a sql server 2…


java - Using both Eclipse and NetBeans on the same project

Eclipse is a really great editor, which I prefer to use, but the GUI design tools for Eclipse are lacking. On the other hand, NetBeans works really well for GUI design. Are there any tips, tricks o…


How do I convince someone they need to upsize from ms access to sql server or similar

I am having a real problem at work with a highly ingrained developer obsessed with ms access. Users moan about random crashes, locking errors, freeze's, the application slowing down(especially in 20…


mysql import sql via cli from remote server

i know how to import an sql file via the cli: mysql-u USER-p DBNAME<dump.sql but that's if the dump.sql file is local. how could i use a file on a remote server?…


How to import Eclipse syntax highlighting profile in Netbeans for Java projects?

I have to use both IDEs and I would like to use the Eclipse style of syntax highlighting in Netbeans. Does any one know how to import it(or change any configuration file)? I've already set Netbeans…


vbscript to export an access query to a tab delimited file not working

I have this code: db="C:\Dokumente und Einstellungen\hom\Anwendungsdaten\BayWotch4\Neuer Ordner\baywotch.db5" TextExportFile="C:\Dokumente und Einstellungen\hom\Anwendungsdaten\BayWotch4\Neuer Or…


“import wx” fails after installation of wxPython on Windows XP

I downloaded and installed this version of wxPython for use with my Python 2.6 installation: http://downloads.sourceforge.net/wxpython/wxPython2.8-win32-unicode-2.8.9.1-py26.exe When I run Python and…


How to convert fields into rows through SQL in MS Access 2007 or MS SQL Server 2005

I have a legacy MS Access 2007 table that contains 52 fields(1 field for each week of the year) representing historical sales data(plus one field for the year actually). I would like to convert thi…





import how file from into not error project data using