topic Data Migration from CSV file to Database Table. in Application Development and Automation Discussions

Data Migration from CSV file to Database Table.

Former Member — Fri, 19 Dec 2008 11:23:53 GMT

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.

Re: Data Migration from CSV file to Database Table.

Former Member — Fri, 19 Dec 2008 11:37:23 GMT

check this documentation

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

hope this helps

regards

Aakash Banga

Re: Data Migration from CSV file to Database Table.

Former Member — Fri, 19 Dec 2008 11:55:10 GMT

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

Re: Data Migration from CSV file to Database Table.

Former Member — Fri, 19 Dec 2008 12:04:09 GMT

go throw this link

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

Re: Data Migration from CSV file to Database Table.

Former Member — Mon, 22 Dec 2008 05:53:43 GMT

Hi Manoj,

Thanks for your input.

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

Thanks & Regards

Raman khurana