Truncated K_Line

[Sheets Guy]

When I use the new Access template I'm getting truncated (as opposed to rounded) values for K_Line (eg. anything between 3.001 and 3.999 comes in as 3).

I'm an Access novice and have been unable to correct this myself. Can anyone please walk me through it?

Thanks!

Sheets Guy

[Rick]

The field should be defined as Number, Single, Auto.

If it was defined as Integer you will need to reimport.

[Rick]

The Import Specification for the field should also be Single.

[Sheets Guy]

Rick:

Thanks.

How do I find the import specification layout? The only layout I see is in \table\design.


Sheets Guy

[Rick]

You need to do a manual import of ALL_HX4.txt.

Open your database.

Click on File, Get External Data, Import.

Change Files of type to Text.

Change Look in to where your ALL_HX4.txt file is located.

Double click on the file name.

Click on Advanced.

Click on Specs.

Select ALL_HX4 Import Specification and click on Open.

That looks like the problem right there. nKLine is defined as byte. Change it to Single.

Click on Save As. Save to the same file name.

Now you are all set.

You will still need to re-import the races.
:mad:

[Rick]

Anyone that downloaded the 14 Jul 04 version of ALL_HX4.mdb need to make the change mentioned in this tread or download the 22 Jul 04 version of ALL_HX4.mdb.

[Sheets Guy]

Worked great Rick. Many thanks.

Sheets Guy

[Rick]

Thanks for bringing it to our attention.