How to get Excel spreadsheet embedded in DB? |
How to get Excel spreadsheet embedded in DB? |
25. Nov 2009, 14:58
Post
#1
|
|
One hit wonder! Group: Members Posts: 1 Joined: 25.11.2009 Member No.: 136 Zertifizierung: keine |
Hello.
I have Access DB with Excel spreadsheets embedded in one of its table. I tried to get this spreadshhets with ADO-tool. SelectData.vi returns 2D array of variants, which could be converted to any data type with Variant To Data function. But when I try to convert it to Excel._worksheet object refnum I've got an error. Could somebody help with it? |
|
|
28. Nov 2009, 08:32
Post
#2
|
|
proven Member Group: Administrators Posts: 315 Joined: 16.10.2006 From: Düsseldorf Member No.: 2 LV Version: current Zertifizierung: CLA LV User seit: 2001 |
sorry, i've never done this: embedding an excel table into an access database and I have no Idea what could be happening there ... maybe you should think about importing the data instead of referencing them? -------------------- künstliche Intelligenz ist besser als natürliche Dummheit!
rotabench:rotierende Prüfstände nach dem Baukasten-Prinzip |
|
|
Lo-Fi Version | Time is now: 13.05.2024 - 10:38 |