Save EXCEL document to ACCESS DB field

[Russ@Davis]

I have a need to store an EXCEL spreadsheet in a field of an ACCESS db table.  It needs to perform the same as the ACCESS cmdInsertObject command so the spreadsheet can be opened from inside of an ACCESS application.  The spreadsheet is a test evaluation from a Labview application.  The ACCESS application is distributed to multiple users.

I am running Labview 7.1 with the current MS Report Generation toolkit and connectivity toolkit.  I successully read/write to the database, including binary data objects, and read/write to EXCEL.  Embedding the EXCEL doc has me stuck.

Thank in advance for any help.

Russ

[Philip_Courtois]

Hi Russ,

I've looked around for further information on this, but didn't find any. Therefore I'm not sure how you would even do this with other programming languages than LabVIEW. What will the data type of the field be? A string or path pointing at the *.xls document or the actual binary file? If you know how to create the field using SQL commands you can do execute those commands directly with the advanced VIs from the LabVIEW Database Connectivity Toolset.

Please answer the above questions and do keep me updated if you get it working, thanks.

[Russ@Davis]

Phillip,

Sorry 'bout the delay.  This is still an open issue.  I missed the email indicating a reply.

The desire is to load the binary excel file in a format that ACCESS recognizes as Excel.  Using Labview, I can store the binary and retrieve the binary and display in Excel.  However, ACCESS does NOT recognize the format as being an *.xls file as it does when you use InsertObject in Access.  If you look at the data table after using the InsertObject, the field identifies the data as Microsoft Excel Worksheet.

Thank you,

Russ

[Philip_Courtois]

Hi Russ,

I'm still not sure how you would be able to do this with applications created with something other than LabVIEW. Since the LabVIEW DB Toolkit makes use of  ADO (ActiveX Data Objects) to communicate with Access through it's OLE DB interface, we have the same ActiveX API available as you would in for example Visual Basic (VB). All we need to know is the steps necessary to do this in VB - then you can implement the same calls with the Property Node and Invoke Node in LAbVIEW.

If you can't do this yourself, please send me the part of a VB (or similar) application that specifies that the type of the field is of the *.xls format. Please don't send a complete program - just the actual calls that specify the field type, thanks.

Message Edited by Philip C. on 11-01-2005 02:06 PM