ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> ODBC General Issues >> Mass updating extracted data
http://www.istechforum.com/YaBB.pl?num=1085432578

Message started by Tag4k on 05/24/04 at 13:02:58

Title: Mass updating extracted data
Post by Tag4k on 05/24/04 at 13:02:58

Thanks to this forum I have learned how to extract data out of DBA using queries within Excel or Access. Now I would like to learn how to take that extracted data and after making mass changes to the data, be able to use that as a source to go back into DBA. Or I need to know that updating DBA with tables is a very complicated thing best left to only those highly experienced in SQL, Visual Basic, or whatever it is that is used for such a process.

Title: Re: Mass updating extracted data
Post by aricon on 05/25/04 at 05:45:10

Taking data out of the DBA tables with Access is quite easy. Getting it back in is REALLY hard and problem prone. It will often work with some of the master tables (BKARCUST and such) but a lot of the tables that are part of a functional schema, BKICMSTR and MTICMSTR as an example, will usually blow up. What you need is an import routine written in TAS.

Title: Re: Mass updating extracted data
Post by Tag4k on 05/25/04 at 12:17:21

Thanks very much for your response. I was hoping someone with your qualifications would reply. Since I don't know TAS or have the compiler, getting data back into DBA is out of the question.

Title: Re: Mass updating extracted data
Post by aricon on 05/25/04 at 13:12:11

Contact Lynn directly. She can have it done for you.