I have a spreadsheet that has validation vbscript written on the first 84 columns. When I go to import this spreadsheet into Access, it will not append to the current table in the datbase as it adds hundreds of columns (up to 255 obviously) to the spreadsheet upon import. When I go to the spreadsheet there is nothing in those columns...I have even selected them all <CTRL/SHIFT Right Arrow> and hit the delete.
Why is it adding all of these phantom columns? I need to get rid of these so it properly does the append import to access.