Search code examples
vb.netdatasourceoledb

Possible to get data source from textbox?

I have now the code below

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Syral.xlsx;Extended Properties=Excel 8.0

I would like to get the data source from a textbox, is this possible?

thanks

Solution 
  • "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & textbox1.text & ";Extended Properties=Excel 8.0"