1
Vote

Space in database table name causes exception and stops operation

description

My MDB file made in access 2003 causes the following exception, which appears to be related to having a space in the table name, since the error says it is looking for a table named "Paste" when there is actually no table named "Paste" but there is a table named "Paste Errors":

C:\PortableApps\Office\MDBtoCSV>MDBtoCSV C:\Users\Owner\SkyDrive\Documents\Finance\Records.mdb C:\Users\Owner\SkyDrive\Documents\Finance\Records_mdb
TablesFound:
Addresses_TOIMPLEMENT
TablesFound:
Appointments
TablesFound:
BusinessCardStacks
TablesFound:
Calls
TablesFound:
Contacts
TablesFound:
Expenses
TablesFound:
InvoiceLines
TablesFound:
Invoices
TablesFound:
OptIns
TablesFound:
Paste Errors

Unhandled Exception: System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot find the input table or query 'Paste'. Make sure it exists and that its name is spelled correctly.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at MDBtoCSB.Program.Main(String[] args)

comments