Another possible HXN bug

[Gar-Bear]

Yesterday I was exporting the new HXN file to look at it and see if I want to use it or not. When I down loaded the template and then imported the new HXN file I found a possible confusing bug. The negatives columns are numbered N00 to N30. I could not find N86 or N88. A pond further research I think I found that N86 and N88 are now renumbered N29 and N30. I look at the coma delimited file and also found the headings to be from N00 to N30. I am not sure what’s going on here however I am getting confused. The PDF spec file even has the N86 and N88 list however I could not find them in the template. Thanks for your help

[Rick]

You got me.

I missed that. I was suppose to catch that.

nN29 and nN30 are fields nN86 and nN88.

[Rick]

I uploaded a new htr template that has the fields titles changed to nN86 and nN88.

In the actual export file the titles are still nN29 and nN30.

[C_Martin]

I am having trouble finding the new template for the HXN. I found the PDF with the specs but no template.

[Rick]

It is included in the latest htr template.

http://www.homebased2.com/km/dnl/htr_templates.mdb

[C_Martin]

Thanks. I just could not find it.

[km]

rats, we got our signals crossed on that one Rick

N29 = 86
N30 = 88

will fix, thanks Charles

[Rick]

I got it fixed in the template.

You can fix it for the seminar upgrade.

Thanks

[Gambler]

Is there anyway i can change thes without downloading the template.
Thanks
ed

[Rick]

Yes.

Delete the ALL_HXN table.

Create an ALL_HXN export file to use for manual import.

These instructions are for Access 2007/2010. The beginning is a little different for earlier versions.

Open htr template database. Delete or rename ALL_HXN table.

Click on External Data tab. Click on Text File.

Browse to the ALL_HXN.txt file you want to import.

You are going to import to a new table. Click OK.

Click Advanced button.

Click on Specs button.

Click on All_HXN Import Specification and click Open.

Drag the scroll bar down till you are at field nN29. Change the name to nN86.

Go to field nN30. Change the name to nN88.

Click Save As button. Accept name and click OK.

Click OK. Click Next. Click Next. Click Next.

Click No primary key. Click Next.

Accept name. Click Finish. Click Close.

Set primary key for that table if you want one.

That should do it.

[zimal2]

I don't use Access, but per Ken's suggestion in early July, I thought I would try HXN export. It looks like I need the needed template has an .mdb extension. In order to open that with Win 7 I need to download a free utility, eg from FileCure. Is that safe? Is there another way? Thanx

[Rick]

You could open it up in Excel.

I could give you directions.

It all depends on what you are trying to do.

You could try OpenOffice.

http://www.openoffice.org/

I have never tried the db in it.