Data Migration from CSV file to Database Table.

[Former Member]

Hi,

I have checked few answered threads on Data Migration Issues but didn't find the solution yet.

I am reading data from an CSV file to internal table but the complete row is coming under one field of the internal table.

How i can get values in different fields of the internal table from the CSV file ?

Thanks & Regards.

Raman Khurana.

[Former Member]

hi

check this documentation

http://help.sap.com/saphelp_nw2004s/helpdata/en/eb/8c683c8de8a969e10000000a114084/frameset.htm

hope this helps

regards

Aakash Banga

[Former Member]

Hi,

If you are using GUI_UPLOAD, you might have missed to make has_field_separator as 'X'.

EXPORTING

CALL FUNCTION 'GUI_UPLOAD'
  EXPORTING
   filename                      = 'C:\File.csv'
   filetype                      = 'ASC'
   has_field_separator           = ' X'  "<= Set this as 'X'.

  TABLES
    data_tab                      = itab.

Regards,

Manoj Kumar P

[Former Member]

go throw this link

http://www.sapfans.com/forums/viewtopic.php?f=13&t=193187

[Former Member]

Hi Manoj,

Thanks for your input.

I tried with Separator 'X' also but still i am facing the same issue.

Thanks & Regards

Raman khurana