Excel Data conversion

From: Hans Kohls (hans_at_meinplanet.de)
Date: 07/27/04 

Date: Tue, 27 Jul 2004 13:37:44 GMT

Hello,

I have to convert the (afaik) Excel (internal) date format into a
different format.
I am wondering if there is a package around to do so. The excel Format
is something like 3NNNN and represents the number of days since 1.1.1900.

Cheers, Hans

Relevant Pages

  • RE: Excel & MS Query caused compile errors
    ... My data is in an Excel file called ... The format of it were distorted after copying and pasting. ... Microsoft SQL Server 2000, which requires a server, VBA or Microsoft Query ...
    (microsoft.public.excel.programming)
  • RE: SSIS date format problem
    ... I think Excel date format is MM/DD/YYYY. ... you may need to adjust your package so that it either always returns ... I test the query in SQL server I got the right date format and also when I ...
    (microsoft.public.sqlserver.dts)
  • RE: Export to Excel: 2nd, 3rd, etc excel files not opening up
    ... early bindings to use the built-in functions of excel to format my excel ... Well based on your suggestions my understanding is that in my early binding ... Set xlApp = New Excel.Application ... I also was able to format that same exported excel ...
    (microsoft.public.access.formscoding)
  • RE: Get parameter dates in heading
    ... And if it goes in Excel where do you put it. ... Const conLightGray As Long = 12632256 ... Dim varGetFileName As Variant 'File Name with Full Path ... Dim strLeftRange As String 'Used to format range references ...
    (microsoft.public.access.externaldata)
  • Re: Dragging data to Excel using DoDragDrop
    ... It just puts a "biff8" object into the clipboard, ... object into Excel. ... if you can use a native Excel data format from ...
    (microsoft.public.dotnet.languages.csharp)