Re: date format

If this is a one time issue, and depending upon the filesize, the easiest
way to handle this just might be to load the file into MS Excel and use the
Edit| Find/Replace capabilitiy to transform the data, save the file as a
csv, and then load it into SQL Server using DTS or however you were planning
to do so.

For example, with the following Replace steps, set the 'By Column' search
criteria, replace 6-mar with 3/1/2006.

Obviously, there will be a few repeated steps to cover all dates, but it may
be quicker than trying to find a way to code SQL to do it. (Yes, it is
possible, but it may not be worth the time and effort.)

Regards,

--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."

*Yet Another Certification Exam


"Tiffany" <Tiffany@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E2B0CE2B-C4BF-40CA-A095-D685D780819C@xxxxxxxxxxxxxxxx
Hi,

I received a csv file which has a date column. The date format in this
column is 6-Mar (6 stands for 2006 which means Mar 2006). I will import
this
data to an sql table and i want to date to look like 3/1/2006. Is it
possible. Kindly advise.

Thank you


.

Relevant Pages

  • Re: date format
    ... The Update/CASE just doesn't change the exception rows, leaving them for you to find and replair. ... impossible to load the entire database in excel application. ... convert it in sql. ... I received a csv file which has a date column. ...
    (microsoft.public.sqlserver.mseq)
  • Re: Importing DBF into SQL CE
    ... Load the data in to dataset using OpenNET CSV adapter and ... insert it from there in to SQL CE. ... how you import the CSV file? ...
    (microsoft.public.sqlserver.ce)
  • Re: transfer data into an external database
    ... >With regards to your SQL code I have no idea about SQL. ... If there is a schema.ini in the same folder as the CSV file, ... >> Create a Schema.ini file based on an existing table in your database: ... John Nurick ...
    (microsoft.public.access.externaldata)
  • Re: Sql ce server process
    ... We are certainly aware of the dll load issue, ... application that is using sqlmobile and is on the virge of disaster. ... running 2 processes at the same time, one that uses the SQL Mobile engine ... unmanaged SQL Compact DLLs is that you need to get them loaded early in the ...
    (microsoft.public.sqlserver.ce)
  • Re: Sql ce server process
    ... We are unlikely to target another platform until WM7 ... My plan is not to try to use sql in any more robust of a fassion than was ... load on the database that is any more heavy than the load that exists today, ...
    (microsoft.public.sqlserver.ce)