thank you very much

I got a new problem...how do i import a pipe delimiter file. This is what I try but it's not working

--Example to open CSV file

SELECT *

FROM OPENROWSET ('MSDASQL',

'Driver={Microsoft...

thanks Adam, you are a genious

still wont work 🙁

SELECT *

FROM OPENROWSET ('MSDASQL',

'Driver={Microsoft Text Driver (*.txt; *.csv)};

DefaultDir=C:\;

Extensions=csv;',

'SELECT * FROM myFile.csv')

Same problem occurs with XLS file and with import wizard as well

I would add the result into a #tempTable and use your group by to count again

no problem...it was very simple once...

CREATE FUNCTION

(

@inputDT int

)

RETURNS datetime

AS

BEGIN

RETURN DATEADD(SECOND, @inputDT, '1/1/1970')

END

GO

I just figure it out. Apparently the apps stores it in Unix Time (UTC.) So I wrote a function to convert it

thanks anyway

For my first issue. I have tried this code in which I found on previous posted

select *

from OpenRowset('MSDASQL',

'Driver={Microsoft Text Driver (*.csv)};

DBQ=C:\myFolder\',

'select * from myFile')

However, I get the...