I need some major help!!! I have two problems.

I have some data in a text file that I imported into access as a table. When I tried to convert my date column as a date access kicks it out as a error on import. If I do text it brings the dates in with no problem. YES problem they need to be dates! I need to find a way to convert this text column to a date one. My format is as 8 characters with the format of yyyymmdd. Any help on how to change this will be awsome!!!

Second problem. The names that I have imported are as follows. Last name, First name, and middle name. I need to put all three of these columns into one column. How do I merge these.



Wanna be Access programmer, (not really just got thrown with a nasty job)

CoNeSsIuS