G
Guest
I have large flat file with fixed record lenght, i have to parse record and
populate table with multi columns with the data,
please any links or code snipets to this topic will be greatly appreciated
OleDbConnection Conn = new
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data
Source=C:\\Archive\\Test.mdb;");
string myInsertQuery = "INSERT INTO ClientsTB (TicketNo, IssueDate,
IssueTime, Location, Notes, Plate) Values('6020012345', '09/05/06', '12:00',
'Main street', 'Test', 'TEST')";
OleDbCommand myCommand = new OleDbCommand(myInsertQuery);
myCommand.Connection = Conn;
Conn.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();
populate table with multi columns with the data,
please any links or code snipets to this topic will be greatly appreciated
OleDbConnection Conn = new
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data
Source=C:\\Archive\\Test.mdb;");
string myInsertQuery = "INSERT INTO ClientsTB (TicketNo, IssueDate,
IssueTime, Location, Notes, Plate) Values('6020012345', '09/05/06', '12:00',
'Main street', 'Test', 'TEST')";
OleDbCommand myCommand = new OleDbCommand(myInsertQuery);
myCommand.Connection = Conn;
Conn.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();