Text to DBF format conversion

Former Member — Tue, 26 Jun 2007 11:13:30 GMT

Hi All,

Can we convert text file into DBF Format for Foxpro, Actually Client want to directly use it as a database file.

Thanks in Advance

Re: Text to DBF format conversion

Former Member — Tue, 26 Jun 2007 11:21:35 GMT

Hi,

Go thru the Following Link,

You try this,

DATA: BEGIN OF ITAB_MATNR OCCURS 0,

MATNR LIKE MARA-MATNR,

COUNT TYPE I,

END OF ITAB_MATNR.

CALL FUNCTION 'WS_UPLOAD'

EXPORTING

FILENAME = P_FILE

<b>filetype = 'DBF'</b>

TABLES

DATA_TAB = ITAB_MATNR

EXCEPTIONS

CONVERSION_ERROR = 1

FILE_OPEN_ERROR = 2

FILE_READ_ERROR = 3

INVALID_TABLE_WIDTH = 4

INVALID_TYPE = 5

NO_BATCH = 6

UNKNOWN_ERROR = 7

GUI_REFUSE_FILETRANSFER = 8

OTHERS = 9.

IF SY-SUBRC <> 0.

MESSAGE E699(PP) WITH 'Unable to load input file' P_FILE.

ENDIF.

Regards,

Padmam.