var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to Migrate the .xls file into tables.
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
Last edited by sql_chinny; 08-03-07 at 06:15.
Reason: reply's form members
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!
Originally Posted by sql_chinny
slap == LOAD DATA INFILE
it's in the manual
I was deliberately being vague