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.ExecuteNonQuery();

{System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement.

at System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at MCS_ImportTool.MCS_ImportTool.QueryImport(String[] fields, String TableName) in C:\Users\Gabiel\Documents\Visual Studio 2005\Projects\MCS_ImportTool\MCS_ImportTool\Form1. 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, 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";

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