SaintAugustine
Technical User
Ugh.
I'm trying to import a file from Excel into Access, since the file has just gotten too darn big for Excel. The problem is, the importing isn't going well. I get an error message at the end, and it turns out that either 1) nothing has been imported or 2) most of the rows have been imported, but some were mysteriously left out.
Possible culprits:
1) The columns in Excel are a mix of data types - specifically, dates sometimes have notes to myself that are text instead of dates.
2) I have blank cells
Also, for some reason, when I'm going through the "import data" dialog windows, I'm *unable* to access the drop-down menu that allows me to pick how the column will be formatted in Access. I think I could fix a lot of problems if I could do this (ie, change the "date" column formatting from "Date/Time" to "text..."
Any help?
Thanks
I'm trying to import a file from Excel into Access, since the file has just gotten too darn big for Excel. The problem is, the importing isn't going well. I get an error message at the end, and it turns out that either 1) nothing has been imported or 2) most of the rows have been imported, but some were mysteriously left out.
Possible culprits:
1) The columns in Excel are a mix of data types - specifically, dates sometimes have notes to myself that are text instead of dates.
2) I have blank cells
Also, for some reason, when I'm going through the "import data" dialog windows, I'm *unable* to access the drop-down menu that allows me to pick how the column will be formatted in Access. I think I could fix a lot of problems if I could do this (ie, change the "date" column formatting from "Date/Time" to "text..."
Any help?
Thanks