Exception When Field Has Two Words Or A Space

Win 7, VS 2013 Express for Desktop, C #

I get exception 80131904 when there basically says Syntax error near 'Checking" when field is '[My Checking]' or the second word if other than checking.

I am writing a checkbook program that adds accounts as tables to the database. The create table sql works fine.

After the table is created I want to enter the first transaction as the opening balance and amount and have the Category be the Account Name in brackets. [oneword] = no exception and the line is entered. [one word] gets an exception.

Here is the sql just before execute:

insert into My Checking(Id, Date, CheckNr, Payee, [Category], Payment, Clr, Deposit, Balance)values(1,'1/1/2014','','Opening Balance',[My Checking],'','','1500.',0)

I have had the code so it says '[My Checking]' in the sql get same results. I have tried it by "[" + Name + "]" and get the same thing.

Here is the Function:

private void AddOpenBal(string Name, string open, string bal) //OFFENDING FUNCTION FOR MULTIPLE WORDS IN TABLE NAME
{
string connetionString = null;
SqlConnection connection;
SqlDataAdapter adapter = new SqlDataAdapter();
string sql = null;

[Code] .....