Skip to Content
avatar image
Former Member

Problem uploading data from MS-Access

Hello Experts,

I have one testdb.mdb file which has 10 tables, I want data from 5 tables in SAP. and few of them tables have more then 9000 records.

I am using Citrix - thin client(linux), Please let me know how to upload these large amount of data without dataloss to SAP.

I have searched forums, and I found that by creating Objects of ADODB.Connection and ADODB.Recordset, we can connect to MS Access database. But I am facing connection error (2). There I think some problem with the provider in citrix machine. Let me know if there are ways to find that.

Plz let me know if any other solutions are available for uploads.

I appreciate your help. Thanks a lot.

Regards,

bh_hir

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 21, 2010 at 01:53 PM

    Can you export the tables from Access to tab-delimited files and store where SAP can "touch"? If so, upload and processing of tab-delimited input is a very simple process.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I have resolved it by using OLE techniques. by connecting to MS Access, and reading records and then manipulating it in a program. It works great now.

      Thanks & Regards,

      bh_hir

  • avatar image
    Former Member
    Sep 21, 2010 at 12:31 PM

    Plz help asap...

    Add comment
    10|10000 characters needed characters exceeded