Insert failed

[engnouna]

Hi

I have SQL Server 2000 table "FilePerson" that contains a field of type varbinary.I want to insert into that field a value like "C:\xx.xls" but the insert failed.
the following message appeared:
Insert into FilePerson(_ID,_Path) VALUES('4','c:\xxx.xls')

Disallowed implicit conversion from data type varchar to data type varbinary, table 'FilePerson', column '_Path'. Use the CONVERT function to run this query.

Any help
thanks

[leinad31]

The error message is self explanatory, just google http://msdn.microsoft.com/en-us/libr...4(SQL.80).aspx

[Hack]

Moved to Database Development

[mendhak]

If it's asking for VARBINARY then it may be that your data type for _Path is not varchar but is varbinary. We shouldn't have to be guessing this though, you should be telling us what the datatypes for your table columns are.

If it is indeed VARBINARY then it is expecting the actual binary data of the file, not the path to the file. You will need to read that file c:\xxx.xls into a stream into a byte array and then pass that in your statement.

[engnouna]

mendhak
_Path is varbinary.

You will need to read that file c:\xxx.xls into a stream into a byte array

how can I read te file into a byte array
thanks