| |
| |
|
Stephan
Sonneborn | thanks for Your Tipps. the the Excel-macro can I now The "alte" method through SENDSTRING Call. is me but a morsel of To unelegant...
therefore wished I time with SQL keep busy.
The Excel-scheduler (*.xls) initialisiere I with
SQLInit_NAVBOM$ = "Driver={Microsoft Excel coachman (*.xls)};DBQ=" + NAVBOMFile$ + ";FIL=MSExcel"
HSQL_NAVBOM& = SQLINIT(SQLInit_NAVBOM$)
the works too, because the lever the DB becomes allocated (is mismatched 0).
But if I then z.B. The first Line the Arbeitsmappe scheduler1 reading wants, comes so a MS-JET-Error Message, that the Objekt scheduler1 not famous be and whether I because well too any Pfadangaben correctly. made had.
my Source is:
SQL$ = "SELECT * FROM scheduler1"
SQLEXEC SQL$, 1
ought to really correctly. his. therefore understand I The Message not...
i'd too gladly The names the Arbeitsmappen of/ one XLS-File read, circa then aimed on a Mappe grab to. moreover Have I of course here and there what found (zb: "SELECT * FROM 'Tabelle1$'") but the working not.
white someone council? |
 |
| |
| Schöne Grüße aus Wittgenstein
von Stephan
Programmierumgebung:| XProfan X4 | WIN10 | AMD FX6100 3,3 GHz | 09/26/10 ▲ |
|
| |
|
|
 | there's sure a suitable "JET"-SQL the The tables first any lists but whom know I do not.  |
|
| |
| |
| |
|
|
Uwe
''Pascal''
Niemeier | Hi Stephan!
The name the Arbeitsmappe/scheduler must in bracket clinging staid go:
SQL$=" SELECT TOP 10 * FROM [scheduler1$] "
How one by SQL on a Overview the available tables comes, would me but too time interested...
PS: Per ocx would it well weg... 
SeeYou
Pascal |
|
| |
| |
| |
|
|
Stephan
Sonneborn | Hi Pascal,
thanks for Info. but unfortunately working the neither... 
I have a Excel-scheduler with 2 Arbeitsmappen: scheduler1 and scheduler2. Nix goes:
SQL$=" SELECT TOP 10 * FROM [scheduler1$] " or
SQL$=" SELECT TOP 10 * FROM [scheduler1] " or
SQL$="SELECT TOP 10 * FROM [scheduler1$]" or
SQL$="SELECT TOP 10 * FROM [scheduler1]"
it comes always these Error Message... |
|
| |
| Schöne Grüße aus Wittgenstein
von Stephan
Programmierumgebung:| XProfan X4 | WIN10 | AMD FX6100 3,3 GHz | 09/26/10 ▲ |
|
| |
|
|
Stephan
Sonneborn | has it!
I had yet ne old XProfan12it Beta installs.... with XProfan12 - Beta13 GEHTS again!!! |
|
| |
| Schöne Grüße aus Wittgenstein
von Stephan
Programmierumgebung:| XProfan X4 | WIN10 | AMD FX6100 3,3 GHz | 09/26/10 ▲ |
|
| |
|
|
ByteAttack | Well. the only I time with Excel made have, is [...] 
but Makros can there unfortunately not read. must time look whether the too somehow differently goes. |
|
| |
| |
| |
|
(1.573)
Deutsch
English
Français
Español
Italia