Inventory To Excel

Posted on 2007-10-10
Last Modified: 2009-04-21
Im looking to get inventory data from accpac 6.5 for dos to some text or some medium that can be easily put into say an excel spreadsheet...Inventory Items and stock qtys and possible prices would be great....The dos info would need to be put into excel or some usable form possibly for a windows xp environment...
Question by:frogglegs
    LVL 33

    Accepted Solution

    I know some of the more recent AccPac stuff has been FoxPro data.  Assuming that your AccPac 6.5 for DOS is also FoxPro data, you could simply use either an ODBC driver, or even the OLE DB Provider for VFP which is backward compatible with earlier FoxPro versions, to pull the data directly into an Excel spreadsheet.

    Obviously, I am assuming your data is FoxPro data in dbf files.

    You can download the free connectivity drivers of your choice at these links:

    Visual FoxPro ODBC Driver (through VFP6)

    Microsoft OLE DB Provider for Visual FoxPro (through) 9.0

    Either one can pull data into a later version of Excel (let's say Excel 2003 for argument's sake).  I just tested the OLE DB Provider for VFP and it worked fine.  But, I only tested it because I already had it installed on this WinXP PC.  I could have just as easily used the VFP ODBC driver I listed above if I installed it.

    Inside Excel, I just went to Data...Import External Data...Import Data.  When the "Select Data Source" dialog box comes up, I went down to the middle bottom and clicked on the "New Source" push button.  That invokes the Data Connection wizard (oh, great! another wizard).  In the list there I chose the bottom one listed named "Other/Advanced" which is your path to using an OLE DB Provider for any data source, but in this case for FoxPro data in dbf files.  Click on "Next" when you have that choice highlighted.  In the next dialog box called "Data Link Properties" you basically see all of the possible OLE DB Provider possibilities ready to use on your PC.  Scroll down and highlight the one that says Microsoft OLE DB Provider for Visual FoxPro.  Click on the "Next" pushbutton.  That will take you to the "Connection" tab.  Click on the box with the ellipsis in it next to the area that wants a entry for "Select or enter a database name".  That will take to another rectangular dialog box called "Configure Connection".  To avoid confusion here (I hope), you need a little background (not much).  Because your data is older, back then FoxPro had no such thing as a database, let alone a database name.  You had dbf files or tables that are known as free tables.  So, in this dialog box you de-select the default, Visual FoxPro database (.DBC) and choose instead the one for "Free table directory".  And, last on that dialog, click on the "Browse" button and point to the location of the AccPac 6.5 dbf file(s) you want to work with.  This does not ask for the dbf yet, simply where the directory/folder is where it (and any others) are located.  Once you click on "OK" it will then present you with a list of all of the dbfs at that location from which you will pick the one you want to import.  Now you're almost done. Once you pick that file, it simply is telling you what special file holds all of that connection information you just painstakingly created.  Since the default is fine, click on the "Finish" push button in the lower right of that Data Connection Wizard dialog box.  It presents you with that .odc file (Ole Db Connection file) and you choose it and finally it gives you a dialog asking you where in the spreadsheet you want to put the data.  I left it at the default ($A$1) and clicked "OK".  The data was immediately pulled into the Excel 2003 spreadsheet.

    I know it sounds complicated, but it's not really.  But it certainly is confusing at first.  You can do the same steps pretty much with MS Word as well.  But, since you mentioned a spreadsheet which holds columnar data really well, I went with that for you.

    I hope this gets you where you want to go.

    I'm exhausted.  Later.

    Assisted Solution

    The 6.5 DOS product (Accpac Plus) is a proprietary database format.  

    Go into the Maintenance menu in IC and check out the export functions. You'll likely have to export to CSV or dBase if you have a lot of items so you don't hit any limits from the export formats.

    You may also be able to find one of the report writers for Plus such as Report Master, Report Master for Windows (Plus version), Quik Reports (from Softrak Systems (best bet for actually being able to purchase it)). They all have the ability to generate reports and export the contents to CSV, Lotus, dBase, etc. Sage Accpac Options did sell an ODBC driver that you could use to pull the data into Excel as Carl has indicated.  However, it isn't in their latest catalogue.

    There are a handful of developers who can write custom Plus applications as well.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    If your app took Google’s lash recently, here are the 5 most likely reasons.
    In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
    Viewers will learn how to use the Hootsuite Dashboard.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now