Hello all,
I have only BO XI 2.0 (no Data Integrator) and want to export some data to a *.CSV file.
When I try doing it from a report (open, refresh, save as EXCEL) the data is to big to handel within a report.
Is there a way to export the data ?
Thanks.
Hello,
A have build 2 Derived tables (same structure) because the SQL script is to long to put it in one.
Can I merge them to one (derived) table ?
I tried this but it would work:
Select * from [DERIVED_TABLE_01]
union
Select * from [DERIVED_TABLE_02]
Thanks
Hello,
I try to import an ASCII file by using the next source:
------
INSERT INTO [ENTITIENAME]
([all-fields])
SELECT [all-fields]
FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0',
'Data Source=[DIRECTORY-NAME]
;Extended properties=Text')...[FILENAME]
-----
It works fine, unless the input...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.