Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

MS Access - Table copy

Former Member
0 Likes
495

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

3 REPLIES 3
Read only

SimoneMilesi
Active Contributor
0 Likes
439

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.

Read only

0 Likes
439

Hi Simon,

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

With Rgds,

Bharani

Read only

0 Likes
439

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

a®