[Fidel]

I am using a microsoft access database to enter all the shooter information for a big upcoming match. There will most likely end up being 300-350 registered shooters.

I am currently running Ezwinscore 3.05 and was told it is possible to import the registration information in EZwinscore from the Microsoft access database.

Has anyone successfully done this before? Any help or at least a nudge in the right direction would be greatly appreciated. Please feel free to IM me or email.

Thanks,

Mike
Boise, ID

This post has been edited by Fidel: 11 April 2009 - 04:20 PM

[hk_mtbr]

I don't know exwin but I do know MS Apps.

Just a shot in the dark...but I would guess you need to export the data/table as excel...then import. This is a typical solution but YMMV...

[Fidel]

hk_mtbr, on Apr 11 2009, 05:49 PM, said:

I don't know exwin but I do know MS Apps.

Just a shot in the dark...but I would guess you need to export the data/table as excel...then import. This is a typical solution but YMMV...

Thanks for the help.

[wgnoyes]

Fidel, on Apr 11 2009, 07:20 PM, said:

I am using a microsoft access database to enter all the shooter information for a big upcoming match. There will most likely end up being 300-350 registered shooters.

I am currently running Ezwinscore 3.05 and was told it is possible to import the registration information in EZwinscore from the Microsoft access database.

Has anyone successfully done this before? Any help or at least a nudge in the right direction would be greatly appreciated. Please feel free to IM me or email.

Thanks,

Mike
Boise, ID

No, you can't import excel into ezws; there's no built-in path to import registrations from any external form into ezws. You instead really need to just go ahead and start registering your folks in ezws the way the system is intended to be used.

Now.... since you HAVE MSaccess, you CAN (if you REALLY know what you're doing) fill the competitor names table within your match file by linking to it through odbc from access, but honestly, I don't recommend it. If you're running a big show like you describe and you've inadvertently introduced any sort of database integrity issues in your match file caused by what I call "jabbing ezwinscore in the side with a fork" (that is, doing any sort of major manipulations of the match file externally from ezws) and your system decides to shred itself for whatever reason at the match....... SHUDDER!!!!

[wgnoyes]

Oh by the way, you need to be running EZWS 3.06, not 3.05. 3.06 fixed a problem where a lower classifier score could be included in the classifier upload file instead of the highest classifier score. Get it from http://www.uspsa.org...e/program.shtml