Re: Accpac Plus Data by MsAccess

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello,

<http://kb.nitix.com/2472>

This page link seems to imply the source databases are either
Btrieve/Xtrieve or DB2.
You should be able to derive the table and field layout ofmr the data
dictionary, and with Xtrieve or DB2 interface drivers, your should be able
to pull teh data.

Depending upon the purpose of your target db, you can either simply rebuild,
or add a date/time field to compare for update or insert handling.

Good luck!
David



"JP Bless" <jp3BlessNoSpam@xxxxxxxxxxx> wrote:
You need to contact Accpac... I think they are now called Sage Accpac. They

usually assist programmers that want to interface to their
database/application. Usually they would give some kind of data(base)
dictionary.


"Pauly" <AccpacToAccess@xxxxxxxxxxxx> wrote in message
news:e$cMbApMHHA.5016@xxxxxxxxxxxxxxxxxxxxxxx
Accpac has approximately 9 tables in each of its modules (AP AR +++ ) and

I
would like to obtain the data from each of these tables with their field
names for use in MsAccess.



Yes, we can export ONE table from each Accpac program (AR = Customers /

AP
= Vendors) in many different configurations like delimited, which
MsAccess
can read, BUT we cannot receive the field names or other tables.



We want to continually receive data from Accpac through MsAccess as this
data will be used for information that will be supplied to a website
store.



Thank you for your very interesting questions.

Mehran

"Phil" <Sorry@xxxxxxxxxx> wrote in message
news:u5pJktnMHHA.4916@xxxxxxxxxxxxxxxxxxxxxxx
Mehran,

These sort of questions can sometimes leave a lot to the assumption of
the
reader/respondent, which is not always correct.

I've never heard of Accpac but you have said 'to obtain individual table
details from Accpac....'. So, Accpac creates it's own tables. Let's
assume
that because it's a DOS-based program then the table is a delimited data
array. MS Access allows for importation of delimited datasets therefore
this
may be one option. Are you intending or looking for a one-off database
creation from your accounts package or are you looking at a way for
access
to continually 'automatically' update from the source files (ie. the
delimited (assumption I know) data)??

Maybe we need some more info!

Regards, Phil

"Pauly" <AccpacToAccess@xxxxxxxxxxxx> wrote in message
news:e9wm$scMHHA.4848@xxxxxxxxxxxxxxxxxxxxxxx
We would like to create an MsAccess.Mdb in office 2000 to obtain
individual
table details from Accpac Plus in Dos (an accounting program)?



Can we receive any ideas or a sample database of how to do this?



Thank you

Mehran









.

Relevant Pages

  • Re: Running Periodic Tasks
    ... >basically process data between two databases on a SQL server. ... >that data and put it in a specific table in DB2. ... >The other vendor, has no such utility. ...
    (alt.2600)
  • Re: Transfering access records between databases via email?
    ... See the insertions below for the examples (untested code) you may need. ... Transfering access records between databases via email? ... When you are ready to send data, have your program first empty tbl1x, ... to be able to click a control button to email her new data to db2. ...
    (comp.databases.ms-access)
  • Re: Mediator & Clipper 5.2e
    ... Stephen Quinn said: ... > instead of writing directly to the databases. ... I already do several .csv exports so that AccPac can import them (e.g., ... and really wants me to modify fields in my .dbf database to get as close as ...
    (comp.lang.clipper)
  • Re: Running Periodic Tasks
    ... basically process data between two databases on a SQL server. ... I have DB1 which generates data in a table. ... that data and put it in a specific table in DB2. ... These are two different vendors' databases. ...
    (alt.2600)
  • Re: Is Xrc a reasonable solution between two databases created separately(in DB2)?
    ... Is Xrc a reasonable solution between two databases created separately(in DB2)? ... DB2 for z/OS itself supports linking multiple DB2s through DDF and DRDA. ... copying or replication don't actually need copying or replication, ...
    (bit.listserv.ibm-main)