OleDb DataSet Retrieving Data from Excel Placing into a SQLTable

[Terry]

My Question is this, I'm having trouble getting the OleDbDataAdapte r to Point
to another connection string and pull the data out of the DataSet I created
from the Excel Spread Sheet and Place it up in a SQL table. I'm Sorry for the
mess of Code but I've been at this all Day now. If you have any Ideas I could
surely use the help.
Thank You,
Terry
string File = ofdExcel.FileNa me;
string sConn = @"Provider=Micr osoft.Jet.OLEDB .4.0;" +
"Data Source="+File+@ ";" +
"Extended Properties=Exce l 8.0;";
OleDbConnection DC =new OleDbConnection (sConn);
DC.Open();
OleDbCommand OC =new OleDbCommand("S ELECT * FROM [Sheet1$]"",DC);
OleDbDataAdapte r OA =new OleDbDataAdapte r();
OA.SelectComman d=OC;
DataSet DS =new DataSet();
DataTable custTable = DS.Tables.Add(" Global");
OA.Fill(DS,"Glo bal");

//--> Clone the old DataSet and create new pointer to DS2
string Oconn = @"Integrated Security=SSPI;P acket Size=4096;Data
Source=""TVIT18 \TVIT18"";Tag with column collation when
possible=False; Initial Catalog=IA;Use Procedure for Prepare=1;Auto
Translate=True; Persist Security
Info=False;Prov ider=""SQLOLEDB .1"";Workstatio n ID=TVIT13;Use Encryption for
Data=False";
OleDbConnection CO2 =new OleDbConnection (Oconn);
DataSet DS2 = new DataSet();
DS2 = DS.Clone(); //-->Clone DataSet
OleDbCommand OC2 = new OleDbCommand();
OleDbDataAdapte r OA2 =new OleDbDataAdapte r();
OA2.SelectComma nd=OC2;

[Angelos Karantzalis]

Perhaps what you need to do is create a DataAdapter on your SQL Server
connection, and call update on it, passing your DataSet as a parameter.

I have my reservations whether that would work however, since the DataSet
stores internal changes to it's data relative to the original Data Source.
So eventually, maybe you'll have to loop through the DataSet & add the rows
manually to your SQL Server tables :(

Angel
O:]
"Terry" <Te***@discussi ons.microsoft.c om> wrote in message
news:74******** *************** ***********@mic rosoft.com...

My Question is this, I'm having trouble getting the OleDbDataAdapte r to Point to another connection string and pull the data out of the DataSet I created from the Excel Spread Sheet and Place it up in a SQL table. I'm Sorry for the mess of Code but I've been at this all Day now. If you have any Ideas I could surely use the help.
Thank You,
Terry
string File = ofdExcel.FileNa me;
string sConn = @"Provider=Micr osoft.Jet.OLEDB .4.0;" +
"Data Source="+File+@ ";" +
"Extended Properties=Exce l 8.0;";
OleDbConnection DC =new OleDbConnection (sConn);
DC.Open();
OleDbCommand OC =new OleDbCommand("S ELECT * FROM [Sheet1$]"",DC);
OleDbDataAdapte r OA =new OleDbDataAdapte r();
OA.SelectComman d=OC;
DataSet DS =new DataSet();
DataTable custTable = DS.Tables.Add(" Global");
OA.Fill(DS,"Glo bal");

//--> Clone the old DataSet and create new pointer to DS2
string Oconn = @"Integrated Security=SSPI;P acket Size=4096;Data
Source=""TVIT18 \TVIT18"";Tag with column collation when
possible=False; Initial Catalog=IA;Use Procedure for Prepare=1;Auto
Translate=True; Persist Security
Info=False;Prov ider=""SQLOLEDB .1"";Workstatio n ID=TVIT13;Use Encryption for Data=False";
OleDbConnection CO2 =new OleDbConnection (Oconn);
DataSet DS2 = new DataSet();
DS2 = DS.Clone(); //-->Clone DataSet
OleDbCommand OC2 = new OleDbCommand();
OleDbDataAdapte r OA2 =new OleDbDataAdapte r();
OA2.SelectComma nd=OC2;