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 |
|
shyler82
Starting Member
4 Posts |
 Posted - 2008-10-20 : 18:09:11
|
| Can anyone help me how to import OLE Objects in Access 2003 which are basically Excel spreadsheet to SQL Server2005.? |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-10-21 : 07:59:08
|
| Try this -http://www.microsoft.com/downloads/details.aspx?FamilyId=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en |
 |
|
|
shyler82
Starting Member
4 Posts |
Posted - 2008-10-21 : 12:21:34
|
| I have convert my OLE objects from Access 2003 to SQL server 2005 but in SQL its stored as <Binary data> in the the column.My question is how i will retrieve/open these files which are stored as <Binary data> |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-10-21 : 12:58:33
|
| It depends - do you want displayed on a web page or windows form? You can't view it in SSIS for sure. |
|
|
|
shyler82
Starting Member
4 Posts |
Posted - 2008-10-21 : 14:16:48
|
| yeah i have an ASP.NEt application. I want to retrieve that file from that webpage so how would i do that? |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-10-21 : 17:03:15
|
| Here's one sample but you can search "asp.net retrieve image sql 2005"http://www.aspfree.com/c/a/ASP.NET/Retrieving-Images-from-a-Database--C---Part-II/ |
|
|
|
shyler82
Starting Member
4 Posts |
Posted - 2008-10-22 : 18:11:32
|
| thanks for the link. It was useful. I have an excel sheet stored as binarydata in SQL. i mean how do i retrieve that on webpage or some user tries to retrieve it and the file will open as a excel sheet separately. |
|
|
|
|
|
|
How to import OLE Objects from Access2003 to Sql