topic Re: MS Access - Table copy in Application Development and Automation Discussions

MS Access - Table copy

Former Member — Mon, 10 May 2010 13:12:20 GMT

Hi All,

There is a Ms-Access DB with 10 tables (Table-A, Table-B ...... ), I need to take a copy of a particular table along with the database and store it in a different location.

Now I m using

CALL METHOD CL_GUI_FRONTEND_SERVICES=>FILE_COPY

method, the problem is its copying the entire access db.

pls suggest.

With Rgds,

Bharani

Re: MS Access - Table copy

SimoneMilesi — Mon, 10 May 2010 13:33:24 GMT

Give a look at FM TABLE_EXPORT_TO_MSACCESS: you can export a table from your report to a DB Access.

I hope this can help you a bit.

Re: MS Access - Table copy

Former Member — Mon, 10 May 2010 13:39:54 GMT

Hi Simon,

my requirement is to copy a table from MS-Access and to store it in a particular location.

With Rgds,

Bharani

Re: MS Access - Table copy

former_member194669 — Mon, 10 May 2010 13:49:16 GMT

Try to use OLE for reading the MS access table the use fm TABLE_EXPORT_TO_MSACCESS

a®