I need to import a file in sql 7.0 database table which has image and float data type fields in it.
I tried with text file, excel file using DTS package but it fails because there is mismatch in source and destination data types.
How do I get this data into table with image and float data types.
Will greatly appreciate any help.
Thank you