Can't get this query to work for some reason

```
SELECT * INTO TableName 
FROM [ODBC;Driver=SQL Server;Server=localhost\SQLEXPRESS;Database=DBName;Trusted_Connection=Yes;].[TableName]

```

Keep getting Error : 

> 
> {"ODBC--connection to 'SQL Serverlocalhost\SQLEXPRESS' failed."}
> 
> 
>