I'm using the export as a backup, there is a menu option to backup data, this
in turn exports all the data in the tables to the .txt files.  This is a
scoring system that is used during matches, the users use the backup to
backup the data for the current match.  If they ever need to go back to a
given match then can do the restore, the program will delete the rows from
the current tables and restore them back to the match they wish to see.  I
also have the users send me the .txt files if they have any problems.  I then
just restore them and can check to see what there problem is.  
Here is the sql of the query, I've only tested with the first time1, like is
said before the extract seems to be working fine, it's now when I try and
restore the data that I get the error regarding the field "5" not in table,
I've set the export to have no headings and have setup a spec. file for the
import but it is still coming up with the same error.
SELECT Scores.SASS_number, Scores.Shoot_date, Scores.ShooterNumber,
Scores.Division, CDbl(Format([time1],"#,##0.000")) AS Time1_, Scores.Rank1,
Scores.Misses1, Scores.Penalties1, Scores.Bonus1, Scores.TTime1,
Scores.Time2, Scores.Rank2, Scores.Misses2, Scores.Penalties2, Scores.Bonus2,
Scores.TTime2, Scores.Time3, Scores.Rank3, Scores.Misses3, Scores.Penalties3,
Scores.Bonus3, Scores.TTime3, Scores.Time4, Scores.Rank4, Scores.Misses4,
Scores.Penalties4, Scores.Bonus4, Scores.TTime4, Scores.Time5, Scores.Rank5,
Scores.Misses5, Scores.Penalties5, Scores.Bonus5, Scores.TTime5,
Scores.Time6, Scores.Rank6, Scores.Misses6, Scores.Penalties6, Scores.Bonus6,
Scores.TTime6, Scores.Time7, Scores.Rank7, Scores.Misses7, Scores.Penalties7,
Scores.Bonus7, Scores.TTime7, Scores.Totaltime, Scores.TotalRank,
Scores.Matchfinal, Scores.ClassFinal, Scores.Scored, Scores.Shootorder1,
Scores.Shootorder2, Scores.Shootorder3, Scores.Shootorder4,
Scores.Shootorder5, Scores.Shootorder6, Scores.Shootorder7, Scores.Extra_1,
Scores.Extra_2, Scores.Extra_3, Scores.Extra_4, Scores.MatchFee,
Scores.CKBox1, Scores.CKBox2, Scores.CKBox3, Scores.CKBox4, Scores.CKBox5,
Scores.CKBox6, Scores.CKBox7, Scores.DNFMDQ, Scores.Horsenumber
FROM Scores;

I just realized that I still have the default windows setting for decimals to
3, when I changed it back to 2 the export of the file went back to only
extracting 2 decimals.  It sure looks like access is using the windows
setting to export the table, and it doesn't matter what the table column is
set to.  When I do the export through the menus and can see the data before
it exports it out to the .txt file it shows there are 3 decimals but when you
look at the exported file there are only 2 decimals exported.  I don't know
what to do now unless there is a different way I could do the backup without
making a complete backup of the whole database.  Do you have any other ideas.
Tom