Working with Excel spreadsheet embedded in access table

[Err]

Hello!

I have Access DB which contain Excel spreadsheet objects embedded in table. To work with DB I use ADO-Tool based on ActiveX. Data passed to my program from GetRows method as 2D array of variants. As I understand I should convert variant to object refnum and then use this refnum with property and invoke nodes to get data from spreadsheet. How to select data type for VariantToData to work with Excel spreadseet?

[A_Patel]

Hi Err,

I will better be able to help you if you post some of your code. Can you post the portion of the code where you are doing the reading?

thanks

Flash

[Err]

Hi, thank you for reply!

I attached VI and Access DB file. In DB I've changed spreadsheet object to wordpad object, but the problem is the same.

[A_Patel]

Hi Err,

You should convert each data type individually. Look at the following post:

http://forums.ni.com/ni/board/message?board.id=170&message.id=213244&requireLogin=False

FLash

[Err]

Hi,

Isn't it the same that using Index Array function? I believe that problem is in conversion of variant to refnum. For example, if I change refnum data type to string in Variant To Data, no error appears, and I've got some text data (see the attachment).

[A_Patel]

Hi Err,

Does the code give you valid values?

FLash

[Err]

Hello,

The last example with string in data type, returns valid string. The previous one returns an error.

[A_Patel]

Hi Err,

What toolkit are you using for the ADOTool VIs?

FLash

[Err]

Hi A_Patel,

I'm using this one http://forum.ib-berger.com/index.php?showtopic=27

[A_Patel]

Hi Err,

What data type is Spector? You should use that specific data type to convert the variant.

FLash