Jump to content

embedded in DB OLE objects

Deployer

By Deployer,
in Database and File IO

Recommended Posts

Deployer Newbie

Deployer

Posted
Posted

Hello!

I have Access DB with Excel spreadsheets embedded in its table. I can get records from DB with GetRows method as 2D array of Variants. If the were some values or text in DB rows I could get it with "Variant To Data" function. But how to work with Excel spreadsheets? Direct conversion to Excel._Worksheet reference generates an error.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
Go to topic listing
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.

  I accept