topic Access to MS SQL Server from ABAP in Application Development and Automation Discussions

Access to MS SQL Server from ABAP

Former Member — Mon, 09 Jan 2006 10:24:38 GMT

Hello!

Is there a simple example how to get content from the table smokna1 from my local MS SQL Server database ides straight into my abap-report? ...and how to put this data back to the table smokna1 out of my abap-report?

Thanks a lot in advance!

Best regards and a Happy New Year 2006,

Ingo

Re: Access to MS SQL Server from ABAP

Former Member — Mon, 09 Jan 2006 10:31:54 GMT

and how to put this data back to the table smokna1 out of my abap-report?

for the above this can be used.

TABLE_EXPORT_TO_MSACCESS_RFC

Re: Access to MS SQL Server from ABAP

Former Member — Mon, 09 Jan 2006 10:36:09 GMT

hi,

check this thread..

Re: Access to MS SQL Server from ABAP

Former Member — Mon, 09 Jan 2006 10:42:09 GMT

Thanks but ...

I don't want a complete export. More something like this:

select the customers from city xyz from the table smokna1 of the local database ides (MS SQL Server) into an internal table of my abap, working with this data and then put it back to the smokna1.

Still any hints and tips?

Re: Access to MS SQL Server from ABAP

Former Member — Mon, 09 Jan 2006 10:45:53 GMT

Thanks a lot for your help.

That's it.

Best regards,

Ingo