topic select query and read dataset in Application Development and Automation Discussions

select query and read dataset

Former Member — Thu, 14 Feb 2008 08:52:22 GMT

i have to read an excel sheet from the application server into an internal table that i hv created.can you help me to write select query &read dataset statement?

suppose the internal table name is T_a and it has fields f1 to f7 which are all present in the excel sheet.

<REMOVED BY MODERATOR>

Thanks in advance,

Anand.

Edited by: Alvaro Tejada Galindo on Feb 14, 2008 2:33 PM

Re: select query and read dataset

Former Member — Thu, 14 Feb 2008 08:54:04 GMT

Is your Excel file of type "Comma Separated Values" (CSV)?

Re: select query and read dataset

Former Member — Thu, 14 Feb 2008 08:54:54 GMT

select f1 f2 f3 f4 f5 f6 f7

from TABLE

into table T_a.

read table T_a with key f1 = <val1>.

<REMOVED BY MODERATOR>

Regards,

Mansi.

Edited by: Alvaro Tejada Galindo on Feb 14, 2008 2:33 PM

Re: select query and read dataset

Former Member — Thu, 14 Feb 2008 09:00:49 GMT

Hi,

The file is a .xls sheet not a csv file.

Re: select query and read dataset

Former Member — Thu, 14 Feb 2008 09:04:10 GMT

Hi Mansi,

I want to read the file from the application server into my internal table having fields f1.....f7 using the read dataset statement.So can you provide the solution for this.

Thanks,

Anand.