Hi There

I am an intermediate user on Excel and am trying to push my boundaries. I am trying to link some rather large Oracle database tables into Excel. I have managed to set up the connection to Oracle but I now need some advice on how I can format the data coming in. I have a date field that consists of the day, month, year and time in one field. What I need to do is split that as it is coming in to Excel so that I can get the data into a pivot table. At present there is to much data to create a pivot table (the max seems to be 64000 rows).

I have an SQL script that does this for me if I am interrogating the data directly in Oracle but it does not work when I enter the script into the advanced field in the Excel data connections box. The SQL script is looking at two tables which I think is confusing matters.

Sorry if I am not fully explaining this and it is not 100% clear but any help would be greatly appreciated.