[AccessD] Date Format

Thanks Drew. You are correct about the data that I
import. If it is in the mm/dd/yyyy format everything
works fine. 

As part of the application I am building, I have to
Import the data using the following code.

DoCmd.TransferText acImportDelim, "BVH", "RawImport",
"C:\Program Files\Leadnet\Data\LEAD.txt"

I made a schema to separate the fields. Can I do
anything at that point to change the Date from mmddyy
to mmddyyyy? I am importing fifty records at a time
give or take.

I am fixing this data with a query and don't know how
to apply your suggestion in a query.

I'm kind of a rookie as you might have guessed.

=====
--------------------
Scott T. Gage
Scott.gage at promedica.org
419.291-7177

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com