Application Development 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: 

Problem uploading data from MS-Access

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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.

4 REPLIES 4

Former Member
0 Kudos

Plz help asap...

Former Member
0 Kudos

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.

0 Kudos

Hi,

Thanks for the reply.

I have tried using that also, But as I have told you its 22 columns and some of that colums have long text so when I delimit the file with '|' then for some of the records it dose not fit into 1 line.

So when I upload that file, in table it comes as next row. so its tough for me to write logic for that. I might not know that how many sub-rows will be there for that one record.

and there are 10000 records in access.

0 Kudos

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