Data from local file option from import link

Kumar Raj Jun 9, 2012 12:03 AM

Currently Being Moderated

How can i import data from a txt file, which has comma seperated values with new line or Pipe symbol for row seperation.

Can i use same data from local file option or should i use teh old way via .ctl file and using sql editor calling .ctl file to load data?

Thanks a lot for the helpful info.

Re: Data from local file option from import link

Anooj Behanan Jun 9, 2012 9:50 AM (in response to Kumar Raj)

Currently Being Moderated

Hi Kumar,

With Revision 28 or 29, you have the option to upload files (yes local files as well) from within the studio under the Import functionality.

There is a nice blog here that explains it step by step: http://scn.sap.com/docs/DOC-27960

Thanks,
Anooj
Report Abuse

Like (0)
Re: Data from local file option from import link

Muralikrishnan E Jun 11, 2012 11:24 AM (in response to Kumar Raj)

Currently Being Moderated

Hi Kumar,

Convert the text file into CSV and then use import from flat file option.Because it supports only csv/xls/xlsx formats.

Rgds,
Murali
Report Abuse

Like (0)