It might be a parameter that is messing up this process. Have you tried different naming conventions and tried to avoid special characters (like < > / \ * & ^ % $ # @ ! ? ... , etc.)? Take a look at the help article here:
Table To Table—Help | ArcGIS Desktop a revisit may be prudent to see if there is anything anew in the required inputs and the destination of your file...
Thanks for your replies. Just got off the phone to some technicians. They said that if I can see the excel tab and tool I should have permission to run the tool. They suggested saving the excel tab as csv (which has worked but also produces a warning that I cannot run the tool with basic but need at least a standard licence... odd given it worked). I will wait to see what technical support finds because it sounds like they think I should be able to run the tool in basic.
If you have an .xlsx file you want to use in ArcGIS but do not have Excel 2007 installed, you will need to install the 2007 Office System Driver. It can be downloaded from the Microsoft Download Center. If you do not have any version of Microsoft Excel installed, you must install that driver before you can use either .xls or .xlsx files. If you have Excel 2010 installed, you must still install the driver. http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displa...
This I know has been the resolution for many other Excel related threads, so may be worth a try. If that doesn't fix it by itself, continue to read in that thread for other suggestions.
