Hello,
I am trying to import a table with dates into Access. Whenever I try to import, Access automatically reads my dates as Short Text instead of a number or a Date with Time. If I try to change the data type (either while importing or after), I end up with a ton of Data Type errors (I'm assuming because a string takes more space than an integer). The original file is a .csv file, but there's no particular reason that it needs to stay that way.
Honestly, at this point, I don't care if it gets imported looking short date or a date value. I think I can change it into something "date-looking" after I get it imported, I just really need to get Access to import anything other than text.
Here are things I've tried:
- Changing the type to short date, number, and general while in Excel
- Importing as .xlsx and as .csv
- Changing the data type after the fact
- Changing the data type after importing
- Getting rid of my Column Names (so that there are no letters to pick up)
Someone I work with suggested using a macro, but I don't know how to use VBA, and while I'm willing to learn, I'm not sure I can afford to put in the time right now unless there's some assurance it would work (I know--I'm the worst).
Does anyone have an idea? You'd be my hero.