I have a workbook in excel that I update each day. I want to link to that workbook in Access, so I can use many of the tools in Access to get the reports I want. My problem is this, I've linked to the Workbook, everything works fine, except several of the columns are formatted wrong in Access. I've gone back to Excel several times to be sure I have them formatted correctly, and I do. For instance, one column in Excel contains numbers, however, in Access, it imported the entire column as text. As a result, I can't use any totals, etc. What I am doing wrong?
I am a novice Access user, and I don't do VBA at all.