![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
Topic Title: Automated import from MS Access Topic Summary: retrieve and modify data within an MS access database Created On: 25-Jul-2007 16:03 Status: Post and Reply |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
Can anyone help with retrieving and modifying data held within an MS access database from within doors using DXL. I need to step through an access database, compare the data with the equivelant DOORS data then align the data so that both databases match.
|
|
![]() |
|
![]() |
|
As far as I know, built-in access to MS Access data is not available from DOORS (this might no longer be the case for the most recent DOORS version, I am still working on 7.0). If your task has to be performed only once, I would propose to export the MS Access data into a .csv spreadsheet, import that into a DOORS module, do all your comparison stuff using DOORS / DXL on the two modules, potentially export an updated module back to .csv and this one back into MS Access. This is of course no good if you need dynamic access the other database.
Peter |
|
![]() |
|
![]() |
|
I'm on 8.1 (soon to be 8.2) and there's no interface with Access that I'm aware of. Does Access use the OLE/COM interface like Excel and Word do? If so you can look to trying to write code that will drive access through DXL in DOORS. But outside of that theres no way to do it short of trying to write a program in C/C++ or some other language that can control both.
You could always export the data of each to Excel and compare them there, then import any changes back into each once they are identical. ------------------------- David Pechacek AAI Services Textron dpechacek@sc-aaicorp.com David.Pechacek@gmail.com |
|
![]() |
|
![]() |
|
Chris P
Do a search here on the forum for "ADO" or "ODBC" and you will like see several threads about doing this. I wrote a series of scripts a few years ago that pulls information from Rational Test datastores (mdb or SQL Anywhere) and in some cases upwards of 100k records. Also use it to update data in our Portal. Cheers Chris W. |
|
![]() |
Telelogic DOORS
» DXL Exchange
»
Automated import from MS Access
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.