• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 455
  • Last Modified:

is there a way to store an sqlite database within a ms word document? that the ms word document can communicate with thru vba macros

I have many word documents that communicate with their own sqlite database it would be great if I could store them together as a single unit is that possible
0
Dov_B
Asked:
Dov_B
  • 2
2 Solutions
 
lcohanDatabase AnalystCommented:
I believe you can store them all in a sqllite db like BLOBs - see below:

http://mornie.org/blog/2007/01/10/Storing-binary-data-in-SQLite/

Then work with them (edit) and save back to SQLLite like:

http://www.powerbasic.com/support/pbforums/showthread.php?t=45848
0
 
GrahamSkanRetiredCommented:
lcohan seems to have misunderstood the question, but that's probably because that way round makes more sense.
You can store a limited number of object types. Sqllite is not listed, but if the that type of database is contained in a single file, you could try to Insert an Object (Insert tab), and choose the 'Create from File' tab on the Object dialogue. It works with Access, but not with MySQL.
0
 
Dov_BAuthor Commented:
what path would I use when communicating with the inserted database
0
 
GrahamSkanRetiredCommented:
Thanks, I don't think that you can access embedded objects in code. I tried with an Excel Workbook:
Sub ProcessEmbeddedExcel()
    Dim ilsh As InlineShape
    Dim xlApp As Excel.Application
    Dim xlWbk As Excel.Workbook
    Dim xlWks As Excel.Worksheet
    
    Set ilsh = ActiveDocument.InlineShapes(1)
    Set xlWbk = ilsh.OLEFormat.Object
End Sub

Open in new window

but it failed on line 8 with error 430 - "Class does not support Automation or does not support expected interface"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now