-
ACCESS Help Converting text to Dates
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|