Hi again.
I managed to get the ODBC link established to MS Access. Now tables appear and can be
linked or imported. This was achieved by doing, for example, SELECT * FROM BLAH
followed by HS.UPDATE.FILEINFO. Problem is, the attributes don't appear in MS Access
- only the records.
So I figured I'd do as was suggested and setup some @SELECTs on the dictionaries and
re-run HS.UPDATE.FILEINFO. I did this on a couple of dictionaries. Problem is, now
when I try to import into MS Access, I get the following error just for those files
that have @SELECTs:
"The Microsoft Jet database engine could not find the object 'NEWONE'.
Make sure the object exists and that you spell its name and the path name correctly.
[OK] [Help]"
Thoughts?
Below is the setup:
>CT DICT BLAH @SELECT
@SELECT
0001 PH
0002 INTO ALTER <- the records I want
>CT BLAH * (to show you the records available)
NUMERIC
0001 K
0002 73
PRINT.ADMIN
0001 PA
0002 MOTIF PRINT.ADMIN.MENU
INTO
0001 K
0002 516
DECATALOG
0001 V
0002 CATALOG
0003 I
0004 GUSZ
0005 decatalog
0006 PICK.FORMAT
ALTER
0001 V
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Ralf Krowke
Sent: Thursday, 26 August 2004 18:57
To: [EMAIL PROTECTED]
Subject: AW: [U2] How import data from UniVerse into MS Access?
Importance: Low
Hi LeRoi,
it could be more simple, but works in my case :o)
With a lot of help of a new "friend" living 800km away from me, I realized
to access Data via ODBC.
First I created a new Account (a simple one, not SB+)
Then I logged to HS.ADMIN and executed HS.ADMIN
Menuchoice "3"
And gave him the new accountname (in my case ALPHA.ODBC) and answered
everythink with Y
I logged to the new Account and "set-file" the files I wanted to read.
The Q-Names I chosed where the same as the original ones and referenced to
the SB+ account (in my case ALPHA)
After that, I edited the DICT's of that files and added a @SELECT -
Statement
f.e.: ED DICT RECHNUNG @SELECT <Enter>
new record.
----:i
0001:PH
0002:NR ADR.NR.S etc. (all fields you want to read)
followed by as many lines just with a blank as fields you want to get access
to
then "save" that and execute HS.UPDATE.FILEINFO
The 0001:PH - line is static, but I didn't figure out, what the hell this
means
I hope, this works for you, if not feel free to ask again....
Greetz
Ralf
-----Ursprungliche Nachricht-----
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Auftrag von LeRoi Keiller
Gesendet: Donnerstag, 26. August 2004 09:52
An: U2-Users (E-mail)
Betreff: [U2] How import data from UniVerse into MS Access?
Is it easy enough to import UniVerse files into MS Access via UVODBC? If
so,
how?
(Currently, I have a UVODBC configuration setup on my PC and it 'test's
okay,
but when I access the nominated UniVerse account via an MS Access Import,
nothing shows up in the window (no tables, files, records... nothing). Am I
doing something wrong? Does ODBC need to be configured on the UniVerse
server, as well, for the particular account? UVODBC is certainly installed
on
client and server.)
Thanks,
LeRoi
LeRoi Keiller
Technical Support
Ultradata - Vision to Reality
+61 3 9291 1700
www.ultradata.com.au
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
