 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 |
|
|
|
|
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
| Lo-Fi Version | Time is now: 18.04.2024 - 03:57 |