Invalid Table name

[Guest]

When trying to import an excel file into my sql db via a adp file, I get a
Invalid table name error. I have db owner perms on the db and I am selecting
an existing table from the drop down list in the import spreadsheet wizard.

 

[Robert Morley]

What's the table name that it's trying to import? Probably it has some kind
of invalid character in it, or maybe it's a reserved word. Try removing any
unusual characters, and just add an extra letter or number to the end so
that it's not likely to be a reserved word any more, and that SHOULD solve
the problem.



Rob