MikeDee
5th October 2004, 06:52.44 AM
It is easy to incorporate the new hxt 7 export into your existing access Db.
ADDING THE HX7 TABLE TO AN EXISTING DB
The first step is to go to the htr2 web site and download the hx4 template Db. This is the most recent version and it has the Hx7 table in it.
Once you have done this go to your current Db and open it up and click on:
File / Import / Get External Data / Import data
The import screen will pop up. In the “look in:” drop down box select the folder where you just downloaded the hx4 template mdb.
Highlight all_hx4.mdb and click on the “import” button.
The “import objects’ box will pop up
In the tab “tables” highlight the all_hx7
Next click on the “macros” tab
Highlight the “Import all_hx7 text file”
Next click the OK tab
This will place the all_hx7 table and the all hx7 import macro into your Db.
Just a note here on the use of an advanced import specification.
If you are going to use the hx7 export and hx7 table template exactly as downloaded, then you will not need a advanced import specificaton. If you want to skip some of the fields and not put them in your HX7 table, then you will need one. Building a advanced import specification is covered in the HTR Access User Manual.
JOINING TABLES
After you have imported hx7 data into the hx7 table in your Db, you can use it as a standalone table and just query it.
You can also use hx7 data in conjunction with hx4 data or any other hx table you have in your Db by joining the tables in a query design.
The easiest way to use the data from multiple tables is to:
Open an existing query that you have with your favorite htr data in the design view.
With your mouse pointer in the top portion of the design screen. (where the tables are shown). Right click and then click on show tables
Highlight the HX7 table and click on it to add the hx7 table to your design grid.
Next join the HX7 table to your existing table in your query design. The HTR Access User Manual covers how to do this on page 24 and 25. It shows an example of joining a hx4 table and a hx3 table. Follow these instructions with the hx7 table and you can then include hx7 fields in your query.
You can also:
A.
Use hx7 data with your hx4 data by adding the hx7 fields you want to the hx4 table.
Or
B.
Take data from any of the hx tables and create a customized table with just the fields you want from any of the hx tables.
If anyone is interested in A or B, let me know and I can provide instructions on how to do this
ADDING THE HX7 TABLE TO AN EXISTING DB
The first step is to go to the htr2 web site and download the hx4 template Db. This is the most recent version and it has the Hx7 table in it.
Once you have done this go to your current Db and open it up and click on:
File / Import / Get External Data / Import data
The import screen will pop up. In the “look in:” drop down box select the folder where you just downloaded the hx4 template mdb.
Highlight all_hx4.mdb and click on the “import” button.
The “import objects’ box will pop up
In the tab “tables” highlight the all_hx7
Next click on the “macros” tab
Highlight the “Import all_hx7 text file”
Next click the OK tab
This will place the all_hx7 table and the all hx7 import macro into your Db.
Just a note here on the use of an advanced import specification.
If you are going to use the hx7 export and hx7 table template exactly as downloaded, then you will not need a advanced import specificaton. If you want to skip some of the fields and not put them in your HX7 table, then you will need one. Building a advanced import specification is covered in the HTR Access User Manual.
JOINING TABLES
After you have imported hx7 data into the hx7 table in your Db, you can use it as a standalone table and just query it.
You can also use hx7 data in conjunction with hx4 data or any other hx table you have in your Db by joining the tables in a query design.
The easiest way to use the data from multiple tables is to:
Open an existing query that you have with your favorite htr data in the design view.
With your mouse pointer in the top portion of the design screen. (where the tables are shown). Right click and then click on show tables
Highlight the HX7 table and click on it to add the hx7 table to your design grid.
Next join the HX7 table to your existing table in your query design. The HTR Access User Manual covers how to do this on page 24 and 25. It shows an example of joining a hx4 table and a hx3 table. Follow these instructions with the hx7 table and you can then include hx7 fields in your query.
You can also:
A.
Use hx7 data with your hx4 data by adding the hx7 fields you want to the hx4 table.
Or
B.
Take data from any of the hx tables and create a customized table with just the fields you want from any of the hx tables.
If anyone is interested in A or B, let me know and I can provide instructions on how to do this