oledbconnection

Excel 2016, I have an OLEDB Query linked to SQL Server to return a table. In prior versions I was able to update command text and refresh the table with the following: Dim strSQL as string strSQL = worksheets("SomeWorksheet").Range("B6") With...

I can usually run the following code without issue, but it sometimes fails to find any records in the record set. The file itself is large - over 200k rows. In addition, it has some merged cells, and the column widths are not wide enough to view the data without auto-fitting (I am not sure...

I want to get a name from user input in inputbox, and then use that name throughout my code in place of [Table2]. See below for sample. I have searched for an answer for a long time. Please Help. Set ws = Worksheets.AddSet pc = ActiveWorkbook.PivotCaches.Create(xlExternal...

I wanted an easy way for a user to change the file path for an excel report that gets run every day. The workbook I'm building is bringing the data from that separate report into a worksheet via an OLEDB connected Table. To do so, I recorded a macro to change the location. Then I modified the...

I want to import XLSX file in SQL database. i am using following C# code. in one column I have data of more than 255 characters. While reading records in Dataset it pick data up to 255 characters only <code style="margin: 0px; padding: 0px; border: 0px; font-size: 13.63636302947998px...