Home Forums SQL Server 7,2000 T-SQL Uploading Data from Text file with different column name RE: Uploading Data from Text file with different column name

  • Thanks david, Thanks a ton for help...

    But i Have already done with this but by other way.. I am still in problem... while putting the data into table in DB... I am Data Type Mismatch error... How to handle that Boss.... U ahve any Idea...

    I will Tell you what i did.

    1 BCP to upload Data into temp table... all in one column.

    2. Used cursor to fetch record one by one.

    3. Extract 1st column as table name and fields. using charindex...Left...Replace and all

    4. I have written SQL script to Insert data into table Dynamically but... Finding problem in Inserting Data in table... Data type mismatch...

    One More question any Idea  : How to Convert Char Data type into Datetime. ?????????????

    Thanks for help

    Raju