select query and read dataset

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

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

[Former Member]

Hi

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

[Former Member]

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.