Yes same error with and without the INSERT INTO language

I am trying to import the data in a specific table. Not sure how to modify this in order to do that.

I moved it out of the Users folder to C:/. Same error.

My data was on "Sheet 1" which I had renamed to "data". I changed it to "data$" and reran the query but got the same error. I also tried...

Thanks for the clarification. I'm using Windows authentication.

Also, not sure what you mean by "it's not your account, but the account for SQL Server."

Both the SQL server and Excel are on my C:/

Not sure what you mean by client. Sorry I'm not a IT professional. Trying to learn this.