Dim da As New OleDbDataAdapter("Select * from [EBU 2 LOB$]", con)
but i want to use this
Dim Sheet1_EBU as string = "EBU 2 LOB$"
so that the code will be something like this i think?
Dim da As New OleDbDataAdapter("Select * from [ & Sheet1_EBU &]", con)
but i have a error it said could not find the the object [ & Sheet1_EBU &]
How can i write it in a appropriate way?
3 Months Ago
Related Article:OLEDB Connection using windows 7 as server
is a VB.NET discussion thread by jbutardo that has 2 replies, was last updated 1 year ago and has been tagged with the keywords: 7, connection, string, vb.net, windows.