Submitted Questions

  • Aug 10 2006
    04:31 AM
    6011
    1

    Load data using Excel file as source and target
    • sasha

    i want to send the excel sheet as a source to another excel sheet as target.so i created a mapping with source excel sheet to target excel sheet correctly. but i'm failing to enter the correct connection string in establishing relational connections for type ODBC .My ODBC data source is XL(Microsoft Excel Driver(*.xls)). tell me what is the connection string for ODBC (Like oracle is the conn...

    Mohamed Ismath

    • Aug 14th, 2006

    Save the source excel sheet as *.csv that is comma delimeted file and then you can import as flat file..Now you are trying to import source and traget as ODBC and there by when you connect the traget ...