Search results for query: *

Arrrgggh! Exporting the appended fields gives me extra fields during export. For instance, the appended fields date and time respectively are: 1/4/1993, 9:30:30 //which the function converted perfectly... again thank you richard which unfortunately export as: 1/4/1993 0:00:00...

Richard Thank you!. This solves the data conversion problem perfectly. It took me a beat to work with functions, as I never have before, but once I got it working it worked like a charm. Very much appreciate your help on this, you are very kind... karma points for you. My only issue right now...

The problem with the "text" solution is that I need to change that format so it can be read by another program. Which means I definitely need to have it in date format. The reason I thought access might be able to do the job, is because the files are huge... csv's on the order of 100-400mb with...

I'm trying to import a csv file that uses a date field as follows: 04JAN1993 and a time field as follows: 9:30:27 Excel opens it right up, but access doesn't seem to want to import the values correctly. Are these nonstandard formats for access? What would be the correct way to import them...