tags:

views:

33

answers:

0
Q: 

how to save excel file in MS SQL Server 2005

I have a table in which there are two columns : 1. import type, 2. Excel import template.

The second column - "Excel import template" should store the whole excel file.

How would I save excel file in databse...can I use binary datatype column, convert excel file to bytes and save the same ?

Thanks in advance !

related questions

Converting troublesome delimited PDF to Excel
How to convert data into DateTime object
best place to get db converted? (SQL Anywhere)
Switching from Linq-To-SQL to Entity Framework for WCF Data Services Issue with FK "Properties"
Convert strings to Java objects automatically
Problem convert column values from VARCHAR(n) to DECIMAL
Convert 4 bytes to int
Using antlr and the DLR together -- AST conversion
Any one aware of what format the OLD IBM PTS (personal typing system) used
how to work with strings and integers as bit strings in python?
Fast conversion from YUY2 to RGB24
Desining a system for mutiple input/multiple output
How to output IEEE-754 format integer as a float
c++ server htons to java ntohs client conversion
SQL server data conversion using Microsoft Sync Framework
Reading Paradox Database files
SQL Server converting a variable varchar field to money/decimal/something with decimal places
SQL Server: EDI to XML Data Conversion
Oracle: Migrating a col. with values, nulls and 0s
How to replace all non-sequential GUIDs with sequential ones?
Matching records based on Person Name
What is the best way to programatically convert a word document with a table structure to XML
Avoiding TSQL Data-conversion errors
Converting CSV File to XML in Java