Hi,

can anyone help me how to migrate the .xls file into another table, where there data type fields are different.

i tried through DTS but iam getting some errors.

Please help me out.

if possible please write the query for that.

----
actually what i have done is i migrated the xls to a new table in the same database which i have to migrate this one to another table..

after migrating the new table i tried to migrate the source to destination table but iam getting some errors like data fields are not matched..

Actually iam new for this SQL queries so please help me out plzzzzzzzz

Slap the XLS file into a table of the same format as the file and then start fiddling with the data..?
No that is not possible, members are here to help, not do your job for you!

slap == LOAD DATA INFILE

it's in the manual

I was deliberately being vague




...honest