export to access

[Shadow]

Ken or Rick, Are place and show payoffs an option to export into access??
Thanks, John aka Shadow

[MikeDee]

John, In the current version of the export win, exa and tri payoff amounts are included

[Shadow]

Mike Dee, Thanks for the reply, but I was looking for the payoffs for place and show.

[MikeDee]

I know you are John, I guess I wasn't very clear, they are not in the export.

[Gramps]

John: you'll find place and show prices in the Impact generated database. If you haven't made one of these go to software here and get Impact. It will export your racefiles to the text file all_impc.txt. you can then create a new database table called all_impc in your database. Once you've done that, you can link the tables and run queries based on place and show prices. There's an article on building relationships (linking tables) in Access on this site under Handicapping Articles.

[Rick]

John,
I finally got around combining the two tables into one. I was surprised at how much disk space that saved.

If you want to combine I can send you my queries for adding progam # field to ALL_MSA and query to append records to new combined table. I will also send you the template for the combined table if you like.

Otherwise, you can still query both tables without combining them by just using the make program # query with the Impc table.

The make program # query just adds the program # to all the other fields. You can then link the track, date, race, & pgm # fields from the make program # query to the fields in the Impc table. Its less work that way.

[Shadow]

Gramps: Thanks for your reply to my thread. I printed out the the artilce regarding (linking tables)

[Shadow]

Rick: Got your reply to my thread. ( THANKS ) I would appreciate it if you would send me the queries you refered to.