Numbers are interpreted as varchar columns by the text file connection

From: Karen Middleton (karenmiddleol_at_yahoo.com)
Date: 10/02/04

  • Next message: Karen Middleton: "SQL BI Wins 5 awards in Intelliegent Enterprise Readers Choice Awards" 
    Date: 2 Oct 2004 05:54:29 -0700

    I am using a Text File (source) connection and the input is a CSV file
    and the first row of the file as column headers. When I try to create
    a destination table DTS interprets columns which are numbers as a
    varchar (255) column but when I save the same .csv file from Excel as
    a .xls file and use a .XLS file as the connection with column headers
    DTS interprets them correctly as a float or double column.

    But I cannot afford to import these files into Excel and save them as
    .XLS file.

    Please can any of you suggest a workaround how I can overcome this
    problem and still get natural interpretation of a number as float or
    double without having to import the .csv file into Excel and save it
    as .XLS file.

    Thanks
    Karen

  • Next message: Karen Middleton: "SQL BI Wins 5 awards in Intelliegent Enterprise Readers Choice Awards"

    Relevant Pages

    • Hidden rows still visuale under CSV
      ... The file Extension .CSV stands for Comma Separated Values. ... When you save an Excel .xls file as a .CSV file only the ...
      (microsoft.public.excel.misc)
    • Re: Problem Connecting to a CSV File in Word 2007
      ... Thank for responding Doug. ... the connection to the CSV file (and seen the data come up in the Word ... The CSV file resides in a subfolder of My Documents. ... In Word 2003 I can connect my document to a .CSV file as my data source ...
      (microsoft.public.word.mailmerge.fields)
    • Re: Read from XLS and substitute values in Ruby (Watir)
      ... Also,Is there a way to read from csv file or xls file because currently ... tokens as separate parameters for the text fields. ... Let's assume that tabs are used instead of spaces between the fields. ...
      (comp.lang.ruby)
    • Re: importing csv to datagrid, adding column data
      ... Robson Siqueira wrote: ... //Function For Importing Data From CSV File ... // Create a connection string as below, if you want to use DSN ...
      (microsoft.public.dotnet.languages.csharp)
    • Re: [PHP] CSV Files
      ... I need to take a record in MySQL and have my user get it as a CSV File. ... After I right out the column headers do I have to put a '/n' to have it ... echo $map_BORROWER_DOB; ...
      (php.general)