What i missing!! please help. Insert query to Acces 2007

[gabielmatos]

this is my query;

string NPI =                fields.GetValue(0).ToString();
            string EntiType =           fields.GetValue(1).ToString();
            string ProvLastNameLegal =  fields.GetValue(5).ToString();
            string ProvFirsName =       fields.GetValue(6).ToString();
            string ProvMiddName =       fields.GetValue(7).ToString();
            string PromNamePref =       fields.GetValue(8).ToString();
            string ProvNameSuffix =     fields.GetValue(9).ToString();
            string ProvCredenText =     fields.GetValue(10).ToString();
            try
            {
                string query = "Insert INTO" + TableName + "(NPI, EntityTypeCode, ProviderLastNameLegalName, ProviderFirstName, ProviderMiddleName, ProviderNamePrefixText, ProviderNameSuffixText, ProviderCredentialText)"+
                 "VALUES(@NPI, @EntityTypeCode, @ProviderLastNameLegalName, @ProviderFirstName, @ProviderMiddleName, @ProviderNamePrefixText, @ProviderNameSuffixText, @ProviderCredentialText)";
                String ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Gabiel\Documents\CMSProv.accdb; Persist Security Info=False";
                //@"Provider=Microsoft.Jet.4.0;Data Source=F:\CMSNPI\200910122000\CMSProv.mdb;User Id=admin;Password=;"; //ACCESS 2003
                OleDbConnection cn = new OleDbConnection(ConnectionString);
                OleDbCommand cmd = new OleDbCommand(query, cn);
                cmd.Parameters.AddWithValue("@NPI", NPI);
                cmd.Parameters.AddWithValue("@EntityTypeCode", EntiType);
                cmd.Parameters.AddWithValue("@ProviderLastNameLegalName)", ProvLastNameLegal);
                cmd.Parameters.AddWithValue("@ProviderFirstName", ProvFirsName);
                cmd.Parameters.AddWithValue("@ProviderMiddleName", ProvMiddName);
                cmd.Parameters.AddWithValue("@ProviderNamePrefixText", PromNamePref);
                cmd.Parameters.AddWithValue("@ProviderNameSuffixText", ProvNameSuffix);
                cmd.Parameters.AddWithValue("@ProviderCredentialText", ProvCredenText);
                cn.Open();
                cmd.ExecuteNonQuery();
                cn.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }
 

the following error ocurrer on this line: cmd.ExecuteNonQ uery();

{System.Data.Ol eDb.OleDbExcept ion: Syntax error in INSERT INTO statement.

at System.Data.Ole Db.OleDbCommand .ExecuteCommand TextErrorHandli ng(OleDbHResult hr)
at System.Data.Ole Db.OleDbCommand .ExecuteCommand TextForSingleRe sult(tagDBPARAM S dbParams, Object& executeResult)
at System.Data.Ole Db.OleDbCommand .ExecuteCommand Text(Object& executeResult)
at System.Data.Ole Db.OleDbCommand .ExecuteCommand (CommandBehavio r behavior, Object& executeResult)
at System.Data.Ole Db.OleDbCommand .ExecuteReaderI nternal(Command Behavior behavior, String method)
at System.Data.Ole Db.OleDbCommand .ExecuteNonQuer y()
at MCS_ImportTool. MCS_ImportTool. QueryImport(Str ing[] fields, String TableName) in C:\Users\Gabiel \Documents\Visu al Studio 2005\Projects\M CS_ImportTool\M CS_ImportTool\F orm1.cs:line 242}

[ThatThatGuy]

Check out this part of the insert statement once again

"Insert INTO" + TableName + "(NPI, EntityTypeCode, ProviderLastNameLegalName
 

there's no space between the INTO keyword and the table name:::: so that's the error point....

[gabielmatos]

Thanks i fix that peace of code but the error still theare!!

string query = " Insert INTO " + TableName + " (NPI, EntityTypeCode, ProviderLastNam eLegalName, ProviderFirstNa me, ProviderMiddleN ame, ProviderNamePre fixText, ProviderNameSuf fixText, ProviderCredent ialText) "+
" VALUES (@NPI, @EntityTypeCode , @ProviderLastNa meLegalName, @ProviderFirstN ame, @ProviderMiddle Name, @ProviderNamePr efixText, @ProviderNameSu ffixText, @ProviderCreden tialText)";
String ConnectionStrin g = @"Provider=Micr osoft.ACE.OLEDB .12.0;Data Source=C:\Users \Gabiel\Documen ts\CMSProv.accd b; Persist Security Info=False";

Ok i need to tell what the data i'm traying to insert to my access data base is from a .csv file. and each fields look like this ("\" 123467"\""")

thanks again for your helps