I've found that it seems to accept the date format "01 JANUARY 2016" but no other format. Not sure why this is a default date type.

I am using VB in Excel to connect to a database used by Business Objects. BO is slow so I am using VB to bypass BO. for example, one report...

Hi Lowell,

I have just tried that, it returned an error saying 'function or procedure TO_DATE is not defined'.

I've managed to get my text to columns macro to work. It takes the report about 20 secs to populate but I can now use the data. Unless you can...

I'm not quite sure what to do with your code tbh. Would it help if I posted my full SQL code (with anything identifiable removed)? (EDIT: full, working code below..anything...

I have a macro-enabled spreadsheet. I'm doing the SQL via a VB script.

I've read around some of the Excel forums, apparently this is a common problem with imported data. Although...

Having gotten what I thought I wanted, sadly the output into Excel can't be summed no matter what format I make the columns.

E.g. The output for what we did...

Yay, this is working well, thanks guys. I've managed to complete my report now. I had wanted to do a subtraction of the result of this code from the result...

Removing the DECLARE and WHERE part I added seems to have worked. I got confused by the original post saying I needed to use them in conjunction with the other...

I'm not sure what to do with the DECLARE part of it. I have added the:

DECLARE @StartTime DATETIME2, @EndTime DATETIME2

at the beginning of my statement and then added to the...

Ah, this is a lot more complex than I'd have hoped. Most important for the result, I have to have the hh:mm:ss format.

ZZmartin, I tried your suggestion, it said...

Hi Lowell, thanks for your help, this runs without error and returns the result in minutes. I modified it so it returns seconds for what I need. However, I was...

I want it to assign a number in a new column if the time was between:

08:00 and 08:15 THEN 1

08:15 and 08:30 THEN 2

etc, and every 1/4 hour up to...

Many thanks for that. It's a bit of a pain sometimes outputting to Excel. I'm using 2010 at present.

So perhaps I could do something like this in the SQL to...

Okay, I've tried both suggestions.

Because the accuracy is important in this project, it seems David's DATEPART suggestion is the most accurate. I rang the DB admin and we went...