Exporting data to Peachtree Accounting (DOS version)

[Joan]

Is it possible to export data from an Access database to
Peachtree Accounting (DOS version)? What is needed to do
this?


Joan

 

[John Nurick]

Hi Joan,

The real question is, can Peachtree import data. If it can, it's likely
to be able to import one or more of the formats Access can export to,
such as .csv text files or dBaseIII .dbf files.

You'll need to check the Peachtree documentation to find out what
formats and fields it expects, and then create a query in Access that
can be exported to provide what Peachtree wants.

 

[Michael S. Montoya]

I would check with the guys as Multiware, Inc: http://www.multiwareinc.com/

they have a utility that links Access to the Windows version of Peachtree
(uses Btreive), and they would probably know if you can link to the DOS
version.

I do know for a fact that you can use Peachtree's Data Query to export data
which can be imported in to Access. I have used this feature to create
reports that could not be created in DOS Peachtree.

If you have any direct questions, my contact info is at
www.uniquedatasolutions.biz

Hope this helps

 

[Joan]

John,
Thanks for answering my post. I think that what I
meant to ask is: Is there a way to make this more of a
user-friendly seamless integration?
I have a client who is currently using PeachTree DOS for
their accounting and would like an Inventory (database
such as Access) program which would share information
between the programs.
They are currently using PeachTree DOS to enter
inventory and generate amount to charge and costs. The
client sells products in bulk amounts and what they charge
is based upon multiple variables such as batch size or
weight, type of product, customer, shrinkage, etc. They
believe Access could handle this function better because
it can be custom designed. Hence, the reason that this
sharing of information needs to be very user-friendly.

Joan

-----Original Message-----
Hi Joan,

The real question is, can Peachtree import data. If it can, it's likely
to be able to import one or more of the formats Access can export to,
such as .csv text files or dBaseIII .dbf files.

You'll need to check the Peachtree documentation to find out what
formats and fields it expects, and then create a query in Access that
can be exported to provide what Peachtree wants.

Is it possible to export data from an Access database to
Peachtree Accounting (DOS version)? What is needed to do
this?


Joan

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

 

[John Nurick]

Joan,

In general DOS programs don't permit any kind of integration, seamless
or otherwise: the typical DOS program believes that it has the entire
computer to itself.

If however the PeachTree installation is a multi-user system whose data
is managed by a server database on the network, it's possible at least
in principle for Access to connect to that database: follow up follow up
Michael's suggestion to find out if it works in practice. (Maybe it
would be necessary to upgrade to a Windows version of PeachTree.)

John,
Thanks for answering my post. I think that what I
meant to ask is: Is there a way to make this more of a
user-friendly seamless integration?
I have a client who is currently using PeachTree DOS for
their accounting and would like an Inventory (database
such as Access) program which would share information
between the programs.
They are currently using PeachTree DOS to enter
inventory and generate amount to charge and costs. The
client sells products in bulk amounts and what they charge
is based upon multiple variables such as batch size or
weight, type of product, customer, shrinkage, etc. They
believe Access could handle this function better because
it can be custom designed. Hence, the reason that this
sharing of information needs to be very user-friendly.

Joan

-----Original Message-----
Hi Joan,

The real question is, can Peachtree import data. If it can, it's likely
to be able to import one or more of the formats Access can export to,
such as .csv text files or dBaseIII .dbf files.

You'll need to check the Peachtree documentation to find out what
formats and fields it expects, and then create a query in Access that
can be exported to provide what Peachtree wants.

Is it possible to export data from an Access database to
Peachtree Accounting (DOS version)? What is needed to do
this?


Joan

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

 

[Joan]

Thanks, Michael.
I will follow your suggestion and check with the people
at Multiware.
It's good to know that at least data can be exported
from Peachtree via Peachtree's Data Query and imported by
Access.
Thanks again,
Joan

 

[Joan]

Thanks John for your reply.

I'm beginning to see exactly what my options are.

Joan

-----Original Message-----
Joan,

In general DOS programs don't permit any kind of integration, seamless
or otherwise: the typical DOS program believes that it has the entire
computer to itself.

If however the PeachTree installation is a multi-user system whose data
is managed by a server database on the network, it's possible at least
in principle for Access to connect to that database: follow up follow up
Michael's suggestion to find out if it works in practice. (Maybe it
would be necessary to upgrade to a Windows version of PeachTree.)

John,
Thanks for answering my post. I think that what I
meant to ask is: Is there a way to make this more of a
user-friendly seamless integration?
I have a client who is currently using PeachTree DOS for
their accounting and would like an Inventory (database
such as Access) program which would share information
between the programs.
They are currently using PeachTree DOS to enter
inventory and generate amount to charge and costs. The
client sells products in bulk amounts and what they charge
is based upon multiple variables such as batch size or
weight, type of product, customer, shrinkage, etc. They
believe Access could handle this function better because
it can be custom designed. Hence, the reason that this
sharing of information needs to be very user-friendly.

Joan

-----Original Message-----
Hi Joan,

The real question is, can Peachtree import data. If it can, it's likely
to be able to import one or more of the formats Access can export to,
such as .csv text files or dBaseIII .dbf files.

You'll need to check the Peachtree documentation to

find
out what

formats and fields it expects, and then create a query

in
Access that

can be exported to provide what Peachtree wants.

Is it possible to export data from an Access database to
Peachtree Accounting (DOS version)? What is needed to do
this?


Joan

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.