Forum Discussion
Importing Data From Excel Via Code Giving Unreliable Outcomes
I have had a look at several forum discussions, however I cant see a work around. Weekly we are importing time cards for my remote staff. The data is captured online via a third party tool. We ...
If you want to take the matter in your hands you need to use Excel Automation...in this case Access will treat Excel as an Object...read the cells and transfer them to a temp table where you can manipulate them to your liking...in this way you are stopping Access from making guesses on what datatype you have thus giving the confusion