Results 1 to 4 of 4

Thread: Export OLE object to Excel?

  1. #1
    Join Date
    Oct 2008
    Posts
    45

    Export OLE object to Excel?

    Hello,

    As part of a project , I tried to export a file from Access to XLS containing the results of requests, but also fixed data (method, date of update formulas, etc.).. I therefore wish to store a "file type" as XLS OLE in a field, then export the results of different queries (transferspreadsheet, etc.).. My problem is that I can not export the XLS file.A file is created in the way you want, but nothing appears in the opening ... Someone would have an idea or have already encountered this problem? please Help me Solve this Thank in advance . Thank you in advance!

  2. #2
    Join Date
    Apr 2008
    Posts
    2,139

    Re: Export OLE object to Excel?

    Hello , Access built-in routine For importing from Excel assumes that the data is in a contiguous block of cells, and grabs the values that Excel has stored for each cell. It doesn't see graphic objects on the worksheet, so your code would have to somehow work out which item in the worksheet's Shapes collection went with which row of data, then get the picture out of the Shape and into the Access OLE field.

  3. #3
    Join Date
    Sep 2005
    Posts
    1,306

    Re: Export OLE object to Excel?

    Hello , From Excel you can easily import files from an Access query (I've already done several times) In the Data tab (Data) select Import / Export, then New Database Query ... Everything is explained in Help Excel (importing data from a database)

  4. #4
    Join Date
    May 2008
    Posts
    4,831

    Re: Export OLE object to Excel?

    To embed a new object…Make a copy of the object and place it in the running directory.Shift down start the database and copy the name of the object to the table.If it’s a font you will also need to check the entry in the table so that it may be registered.Close and re-start.The database is a little unusual in that it contains and uses no references to DAO or ADO.
    It converts up to A2K without problems. Because of the AutoExec Macro, A2K3 users may get a warning.

Similar Threads

  1. Export Gridview to Excel in VB.Net
    By Ariadne in forum Software Development
    Replies: 4
    Last Post: 15-06-2010, 06:30 PM
  2. php export to excel
    By Derwin in forum Software Development
    Replies: 3
    Last Post: 25-08-2009, 06:25 PM
  3. Cannot insert object in excel 2007
    By Darpak in forum Windows Software
    Replies: 3
    Last Post: 04-08-2009, 07:06 PM
  4. Export to Excel
    By nehal_serpa in forum Microsoft Project
    Replies: 6
    Last Post: 11-12-2008, 12:44 AM
  5. How to export AD object ACL
    By TheJoel in forum Active Directory
    Replies: 3
    Last Post: 28-01-2008, 05:29 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,725,150.85964 seconds with 17 queries