Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
im1dermike
Posting Yak Master
222 Posts |
 Posted - 2009-12-09 : 12:28:34
|
| I know how to write a file (eg. *.xls) to a database table as a varbinary(max) using C#, but can it be done directly in T-SQL in a stored procedure?Thanks |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2009-12-09 : 15:02:14
|
You can access and manipulate xls files by using openrowset.select * Into #TmpfromOPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;DATABASE=C:\Myfile.xls', 'Select * from [Sheet1$]') a
Success is 10% Intelligence, 70% Determination, and 22% Stupidity.\_/ _/ _/\_/ _/\_/ _/ _/- 881 |
 |
|
|
DP978
Constraint Violating Yak Guru
269 Posts |
Posted - 2009-12-09 : 15:53:44
|
| Question:I tried this for kicks, changing the path to one of my own, and I got the msg :Msg 7403, Level 16, State 1, Line 1The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.Anyone know what this means?(From what Ive looked up it appears the Jet OLEDB is not compatible with 64 bit SQL 2005??) Source:http://social.msdn.microsoft.com/Forums/en-IE/sqldataaccess/thread/60dc2b9a-eddb-4a13-8c87-e96655be9fca |
|
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2009-12-09 : 18:50:25
|
The 64 bit dll Is available, just google it for the download link.
Success is 10% Intelligence, 70% Determination, and 22% Stupidity.\_/ _/ _/\_/ _/\_/ _/ _/- 881 |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
|
|
T-SQL: Writing file to database table