Go Back > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 54

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 4th July 2002, 18:11
Maxali Maxali is offline
Junior Member
Join Date: May 2002
Posts: 8
Maxali is on a distinguished road
Microsoft Excel in Baan

Hi all
we use Baan IV and Unix IBM Aix
i want to get data in online with winNT it works
but Unix I do not how if sombody can helpe me
i will appriciate it.
Reply With Quote
Old 4th July 2002, 23:29
alejandro's Avatar
alejandro alejandro is offline
Senior Member
Join Date: Feb 2002
Location: Madrid - Spain
Posts: 144
alejandro is on a distinguished road
Baan: IV c4 - DB: Oracle 8 - OS: Unix

What do you mean exactly with online data?
There are some ways to put data from BaaN-Unix to Excel.
In the forum you can find many threads and some code about how to do it.

In our system we use three different procedures:
1.- You can customize one existing report and put out page headers and footers, change separator to |, for example and put in the first line field names. Then select device Excel (how to create is is also explained in the forum) and excel will launch with this data.

2.- Use seq functions to create the output, then client2server and then app_start (functions from ttdllbw BaaN's dll) to execute excel passing text file created to be opened with excel.

3.- Use AFS from vba Excel and use ttstpsql_query function dll to get data in BaaN. See examples in your PC BaaN folder.

There are some other ways but I think you should better explain your requirements.

Hope this helps.
Reply With Quote
Sponsored Links

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
BaaN IV ODBC to Microsoft Access 2000 jun lopez Operating Systems & Databases 1 20th September 2004 21:34
Is Invensys really planning to sell Baan? baanassist General Discussion & Chat 10 3rd September 2002 19:29
Question on integrating Excel with BaaN. r_nagu Tools Development 48 15th August 2002 16:06
Baan Report ---- Excel Kai's Forum Users Deutsches Forum 1 8th August 2000 01:00

All times are GMT +2. The time now is 09:15.

©2001-2018 - -