Import data from an Excel file to SQLExpress database  
  Index ‹ .NET Development ‹ .NET Framework Data Access and Storage
Author Message
bthumber
PostPosted: .NET Framework Data Access and Storage, Import data from an Excel file to SQLExpress database Top

Good morning,

I saw how I could use the Insert command to bring over the data into my SQLExpress database:

Would that be in the program I'm writing or should I do it from the database

I don't understand the connection string ('Microsoft.Jet.OLEDB.4.0',Excel 8.0; Database=\\svrsqlLive\Processing\PATIENTS.xml;HDR=YES;

Brent

.NET Development16  
 
 
VMazur
PostPosted: .NET Framework Data Access and Storage, Import data from an Excel file to SQLExpress database Top
What do you need to achieve You need to be more specific.

 
 
Paul P Clement IV
PostPosted: .NET Framework Data Access and Storage, Import data from an Excel file to SQLExpress database Top


The connection string would be specified in your application. What is it that you don't understand about the connection string Also your Data Source appears to be an xml file and not an Excel file.

As Val mentioned, you may want to provide a bit more information.



 
 
 
Index ‹ .NET Development ‹ .NET Framework Data Access and Storage