• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 926
  • Last Modified:

Inventory To Excel

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...
0
frogglegs
Asked:
frogglegs
2 Solutions
 
CarlWarnerCommented:
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)
http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx

Microsoft OLE DB Provider for Visual FoxPro (through) 9.0
http://www.microsoft.com/downloads/details.aspx?FamilyId=E1A87D8F-2D58-491F-A0FA-95A3289C5FD4&displaylang=en

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.
0
 
SilentDCommented:
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.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now