Often times business utilize Microsoft Access to manage their day to day operations and need an easy way to transfer or import this data into their QuickBooks company file. This article will give you some tips on how to automate the import process once you have had several successful manual imports.
You will find all the command line parameters used below in this article. If you use the command lines at the bottom of this article all the user needs to do is just launch Transaction Pro Importer 5.0 for QuickBooks and the wizard will run on its own from there. To take it a step further you could create a batch file and schedule the process via Windows Scheduler. If you need assistance or writing batch files just do a Google search for “creating batch files” and you will see a lot of helpful web sites.
Now we will give you an example command line that you could use to automate this process. For purposes of the example below assume the following:
- Query in Access is named Query1
- Access database is located in c:\db1.mdb
- Import type is invoice
- Map file is located at c:\Invoice Map.dat