Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel spreadsheet parsing
- Thread starter djam
- Start date
"what are you trying to do... can you can connect to it and pull information just like a database....
I am pulling it from some vb code... but you can get the idea...
Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + ProcessFile + ";Extended Properties=Excel 8.0;"
Dim ole As New OleDbConnection(sConnectionString)
ole.Open()
Dim olecommand As New OleDbCommand("select * from tblCustomers", ole)
Dim olread As OleDbDataReader = olecommand.ExecuteReader()
you can probably take it from there...
I am pulling it from some vb code... but you can get the idea...
Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + ProcessFile + ";Extended Properties=Excel 8.0;"
Dim ole As New OleDbConnection(sConnectionString)
ole.Open()
Dim olecommand As New OleDbCommand("select * from tblCustomers", ole)
Dim olread As OleDbDataReader = olecommand.ExecuteReader()
you can probably take it from there...
- Status
Similar threads
- Locked
- Question
