×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Import sales figures from access DB into Accpac 6.0 for Dos

Import sales figures from access DB into Accpac 6.0 for Dos

Import sales figures from access DB into Accpac 6.0 for Dos

(OP)
Hello,

   I have a client who needs their sales software for their business redone from ground up.  We will be developping their software using VB and MS Access.  The client expressed the desire to have all the invoices of the day to be exported into his Accpac software.  I have read the  Thread631-431945 which seems to be what I'm looking for, but I'm not too sure.  I'm the person mostly doing the research and handing over the info for the programmer.  I would like to know how this could be done or can someone point me into the right direction.  I have no knowledge of how accpac works nor what's the structure of the data files.  For now, I know that the onsite accountant keys in all the invoices from the previous day into Accpac.  I noticed that there was an Import function.  

Thank you
Anthony

RE: Import sales figures from access DB into Accpac 6.0 for Dos

Hi,

There is an import function. the layout is in the manual or you can maybe get it somewhere on the web? The easiest way is to use Softline's ODBC driver for Accpac Plus. Dont know if they still sell it even but maybe you can track them down. That way you write directly to the database. Hope that helps a bit, as late as it was.

Regards

e

RE: Import sales figures from access DB into Accpac 6.0 for Dos

In case anyone else comes across this thread, the product e is referring to is now an ACCPAC Options product (Softline was bought by ACCPAC and became ACCPAC Options).

The ODBC driver will allow you access but doesn't maintain any business logic so you have to learn the whole process.  You'd be better of tracking down Order Import (which may no longer be available).  That product allowed you to generate a text file in a variety of formats and it would maintain the business logic.

Django

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close