Click here to Skip to main content
15,919,500 members
Home / Discussions / C#
   

C#

 
GeneralRe: Speed Hack Pin
Dave Kreskowiak25-Jan-05 8:26
mveDave Kreskowiak25-Jan-05 8:26 
GeneralRe: Speed Hack Pin
Budi Zhu25-Jan-05 11:27
Budi Zhu25-Jan-05 11:27 
GeneralRe: Speed Hack Pin
Dave Kreskowiak25-Jan-05 14:43
mveDave Kreskowiak25-Jan-05 14:43 
GeneralRe: Speed Hack Pin
Robert Rohde25-Jan-05 19:12
Robert Rohde25-Jan-05 19:12 
GeneralVb.net to C# conversion Pin
MyThread25-Jan-05 6:23
MyThread25-Jan-05 6:23 
GeneralRe: Vb.net to C# conversion Pin
bneacetp25-Jan-05 18:55
bneacetp25-Jan-05 18:55 
GeneralRe: Vb.net to C# conversion Pin
Dave Doknjas29-Jan-05 7:51
Dave Doknjas29-Jan-05 7:51 
GeneralRetrieve VBA-DAO inserted Blob Data into Access Pin
Paul Kennedy25-Jan-05 5:57
Paul Kennedy25-Jan-05 5:57 
I have a situation where I am utilizing code from MSDN to insert XLS files into a Microsoft Access Table in a column of Ole Object using VBA and DAO. That code also provides me with a method to extract the XLS files later. This works wonderfully.

The Article is 103257, ACC: Reading, Storing, & Writing Binary Large Objects (BLOBs) http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/oledbaccessing_blob_data.asp

I next transfer that data to a Dataset and then to SQL Server. I found the following articles on MSDN which show how to insert and extract BLOB data using Visual C#.

The Articles are

317016 How to read and write a file to or from a BLOB column by using ADO.NET and Visual C# .NET http://support.microsoft.com/default.aspx?scid=kb;en-us;317016

and

317043 How to read and write a file to and from a BLOB column by using chunking in ADO.NET and Visual C# .NET http://support.microsoft.com/kb/317043

These work on extracting XLS files which were previously inserted using C# but fail to extract readable copies from the XLS files previously inserted via VBA.

Things I have noticed.

1. The OLE Object size in Access is twice the size of the original file.
2. When the OLE Object is extracted using VBA-DAO, the file size is back to that of the original file.
2. The OLE Object size in Access is equal to the BLOB size in SQL Server.
3. When the BLOB is extracted via C# from SQL Server, the extracted file size matches the BLOB size exactly.

Please Help!

Does VBA-DAO and OLE Objects included some sort of encoding on insertion which I must replicate C#?

Paul Kennedy

Father/Son/Husband/C Programmer
What else could you ask for?
GeneralDLL Version number Pin
PaleyX25-Jan-05 5:15
PaleyX25-Jan-05 5:15 
GeneralRe: DLL Version number Pin
Dennis C. Dietrich25-Jan-05 5:42
Dennis C. Dietrich25-Jan-05 5:42 
GeneralStrange Errors, Behavior Pin
tdciDoug25-Jan-05 4:41
tdciDoug25-Jan-05 4:41 
GeneralUrgent!!PLEASE Pin
innocent7325-Jan-05 4:41
innocent7325-Jan-05 4:41 
GeneralRe: Urgent!!PLEASE Pin
Jon Sagara25-Jan-05 6:26
Jon Sagara25-Jan-05 6:26 
GeneralRe: Urgent!!PLEASE Pin
Alex Korchemniy25-Jan-05 6:41
Alex Korchemniy25-Jan-05 6:41 
GeneralRe: Urgent!!PLEASE Pin
innocent7325-Jan-05 19:02
innocent7325-Jan-05 19:02 
GeneralRe: Urgent!!PLEASE Pin
ye win zaw25-Jan-05 17:05
ye win zaw25-Jan-05 17:05 
GeneralFinding the user's choice of install location Pin
mikey_g25-Jan-05 3:55
mikey_g25-Jan-05 3:55 
GeneralRe: Finding the user's choice of install location Pin
mav.northwind25-Jan-05 5:20
mav.northwind25-Jan-05 5:20 
GeneralRe: Finding the user's choice of install location Pin
RNEELY25-Jan-05 6:21
RNEELY25-Jan-05 6:21 
GeneralRe: Finding the user's choice of install location Pin
mikey_g25-Jan-05 6:37
mikey_g25-Jan-05 6:37 
GeneralDefining excepion Pin
Paolo Ponzano25-Jan-05 3:41
Paolo Ponzano25-Jan-05 3:41 
GeneralRe: Defining excepion Pin
Dennis C. Dietrich25-Jan-05 4:03
Dennis C. Dietrich25-Jan-05 4:03 
GeneralProgrammatic Break Points Pin
MrEyes25-Jan-05 1:10
MrEyes25-Jan-05 1:10 
GeneralRe: Programmatic Break Points Pin
leppie25-Jan-05 2:40
leppie25-Jan-05 2:40 
GeneralBattery power Ramaining Pin
Amir Jalaly24-Jan-05 23:50
Amir Jalaly24-Jan-05 23:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.