Problems with reading date/time format from SQL server

L

lordslayer

Helo!

I made a pivot table. I get data from external source - SQL server. On
of the columns is date/time type. For some reason unknown to me, Exce
doesn't read this dates correctly. Instead of dots between months an
days it puts little squares .. ?!? I opened the same file on m
coworkers comp. and it works just fine.

If anyone has already encountered this and knows how to fix it ..
plase reply.

thnx

j
 
G

Gerrit-Jan Linker

There may be some difficulties getting external data properly into
Excel. If not done correctly you cannot use the data in formulae e.g.
or like you experience, it's a complete dog's breakfast.

I've tried to overcome all these problems with a program I wrote 6-7
years ago. Perhaps you wish to try it. The program is called SQL*XL.
It adds full database support to Excel. You can query, insert and
update queried data all from Excel. I've also added support for
Excel's macro recording so everything you do can be recorded into
scripts.

You find SQL*XL at www.oraxcel.com
Hope you enjoy using it.

Best regards,

Gerrit-Jan Linker
Linker IT Consulting Limited
www.oraxcel.com
Author of SQL*XL
 
Top