ThatJeffSmith

Tag: Excel

Data Modeling via Excel?

In SQL Developer if you use the Import Data feature from the main tree node, it will create a new table based on a delimited text or Excel file. We’ll look at the data and create some columns for you. In version 4.1, we’ll recognize numbers as numbers, dates as dates, and try to get […]

Using Oracle SQL Developer to Setup SQL*Loader Runs

I’ve done a couple of posts on how to use SQL Developer to load your Excel files to an Oracle table. However, I always wonder how many folks realize there may be a ‘better way.’ If you are loading data to Oracle on a regular basis, there’s a few things I want you to know […]

How to Import from Excel to Oracle with SQL Developer

This question comes up about as frequently as the ‘how do I export data to XLS?’ question. It’s pretty simple once you’ve ran through the process a few times. But you may be here because you’ve never ran through the process before. This post will step you from beginning to end. You should be prepared […]

Three (4) Ways to get Data into Excel with Toad

I have been really hard on Excel lately. Excel is an excellent tool. Tools can be misused and abused, but it’s not their fault. I should know this being an advocate for Toad, but I digress. Updated on 1/5/2011 to include 4th Method and add note on ‘Display all results in grid’ option. You want […]

Access of Evil

A play on words – the Axis of Evil, three countries that foster or promote terrorism. This is not a history lesson or political discussion, go here for that. So what is the Access of Evil? I would propose that the following practices conspire to bring down any well-ordered collection of data: MS Access MS […]

Excel and Oracle? Yes, but Should You?

Microsoft has a lot to be proud of. They helped pioneer desktop computing. They have very successful platforms like SQL Server and Sharepoint. They are even working on a new mobile phone that doesn’t support copy and paste. But, I would argue their most popular product in use today is Excel. Mayhaps ‘popular’ isn’t the […]