Uploading AREV LH tables to MS SQL 7.0 (AREV Specific)
At 19 JUL 2000 06:13:05AM MKSim wrote:
We are in the process of implementing SAP R/3 running on Windows NT with MS SQL Server 7.0 as our database for our finance, sales and material management.
We also have an industry-specific application running in our operations, which SAP R/3 can not replace at the moment.
Can anyone advise us on the easiest way of uploading data from our AREV system to the SQL database.
MKSim
At 19 JUL 2000 07:01AM Mike Ruane, WinWin Solutions Inc. wrote:
MK-
Arev includes Import/Export utilities that would let you export the data in ascii, and then you could BCP it into SQL.
Depending upon your version of Arev, the menu might be Utilities-Export-Ascii, or something similar.
Hope it helps-
Mike Ruane
WinWin Solutions Inc.
WWW.WinWinSol.Com
At 19 JUL 2000 11:18AM Warren wrote:
And the rub is that multivalued data needs to be normalized prior to exporting…
At 19 JUL 2000 11:48AM Mike Ruane wrote:
Yep.
Although an exploding sort helps a lot…
At 19 JUL 2000 01:37PM Larry wrote:
I can give you some advice on this. Email me at:
Larry Wilson
At 21 JUL 2000 11:59AM Warren wrote:
Does this work? I just looked at the source to EXPORT.ASCII and it is not coded to handle exploding sorts (e.g. READNEXT @ID vs READNEXT @ID,WHICHVAL)
At 21 JUL 2000 02:15PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Funnily enough we've just interfaced one of our client's (Penguin Books) Marketing Production systems to SAP/R3. However if you want to export the data there are a very good couple of articles here.
World Leaders in all things RevSoft
At 22 JUL 2000 02:05PM Warren wrote:
Sprezzies Rock!