topic Re: Problem uploading data from MS-Access in Application Development and Automation Discussions

Problem uploading data from MS-Access

Former Member — Mon, 20 Sep 2010 21:24:14 GMT

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

Re: Problem uploading data from MS-Access

Former Member — Tue, 21 Sep 2010 12:31:04 GMT

Plz help asap...

Re: Problem uploading data from MS-Access

Former Member — Tue, 21 Sep 2010 13:53:10 GMT

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.

Re: Problem uploading data from MS-Access

Former Member — Tue, 21 Sep 2010 14:48:49 GMT

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.

Re: Problem uploading data from MS-Access

Former Member — Tue, 21 Sep 2010 21:35:27 GMT

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