Hi all,
I need to upload a DBF (Fox Pro, DBase) file into an internal table within an ABAP program.
I have looked at the function module "GUI_UPLOAD", but I have 2 problems with it:
- I need it to work in background mode, on the application server
- It does not that the 'DBF' filetype option on our system.
Does anyone have an alternative?
3 Answers
-
Best AnswerPosted on Jul 14, 2006 at 12:34 PM
Hello Stuart,
I have programmed a DBase file importer that extracts the file definition and moves each corresponding table field dynamically into a predefined internal table according to it's structure (inclusive data conversion for the most well-known fields: char, numeric, date)
If you're interested I could mail you the coding.
Best wishes,
Florin
Add a comment
-
Former MemberPosted on Jun 12, 2006 at 08:30 AMHi stuart,
1. I need it to work in background mode, on the application server
Yes, it will not work.
(bcos it needs an active front-end)
So u will have to use OPEN DATASET, READ DATASET , CLOSE DATASET
commands for reading file from app server.
2.
It does not that the 'DBF' filetype option on our system
I think it would be quite difficult
for reading a BINARY DBF file
and making sense out of it.
*----
3. Your requirement can be stated in another way like this :
To upload .XLS file
from application server
in background mode
(This is pure .XLS file, not Tab delimited file)
4. While using OPEN DATASET,
we read the BINARY CONTENTS OF THE FILE,
which will not make any sense of the XLS format.
regards,
amit m.
Add a comment
Add a comment