No announcements
Found 3466396 threads
-
1 Voteshow to get the column names of the table excel in vb.net
now , when i select the name of the column : -this column will be copie in a new sheet of the same workbook (a new ...Answered | 10 Replies | 7126 Views | Created by tamaratheo - Wednesday, March 18, 2015 10:21 AM | Last reply by Armin Zingler - Wednesday, March 18, 2015 12:29 PM
-
10 Votes
How to Alter Table Column Name in Microsoft Access table using VB.NET
The poster is using vb.net.Answered | 21 Replies | 29524 Views | Created by Colin Reid - Friday, October 23, 2009 2:00 PM | Last reply by Albert D. Kallal - Saturday, December 12, 2020 10:29 AM -
2 Votes
How to add a column to an Excel file using vb.net?
So do you know how I can move it from the first to the column (making it the last column)?Answered | 12 Replies | 13541 Views | Created by Ade_O - Thursday, May 6, 2010 11:28 PM | Last reply by Ade_O - Thursday, June 3, 2010 3:27 AM -
1 Votes
Excel->SSIS: Named tables
Benefits of the tables is that its range dynamic by adding columns and rows manually.Answered | 16 Replies | 2283 Views | Created by mamoel - Wednesday, July 3, 2019 10:55 AM | Last reply by Yitzhak Khabinsky - Friday, July 5, 2019 6:35 AM -
0 Votes
GetOleDbSchemaTable - Extract Excel Column names
I am being slowly driven crazy trying to get a list of Excel column names using GetOleDbSchemaTables.Answered | 2 Replies | 10652 Views | Created by B_E_L - Wednesday, November 5, 2008 6:23 PM | Last reply by Vijay Mullick - Thursday, November 6, 2008 6:14 AM -
2 Votes
table columns name
If you want to have the list of fields names, use AFIELDS().Answered | 2 Replies | 2303 Views | Created by Alaa Mukhtar - Wednesday, May 9, 2012 10:54 AM | Last reply by Tamar E. Granor - Wednesday, May 9, 2012 8:37 PM -
0 Votes
Problem getting SQL Server Table Column Names
Try to include schema name as without schema it returns NULL for object_id, so, your query should be use AdventureWorks2012 SELECT COLUMN_NAME,Data_type ...Answered | 2 Replies | 2826 Views | Created by AugustWind - Monday, August 6, 2012 1:35 PM | Last reply by Naomi N - Monday, August 6, 2012 1:41 PM -
0 Votes
Script task to read the column names dynamically and create a table in database based on excel column structure
Refer the below script to read columns in each sheet.Answered | 3 Replies | 4205 Views | Created by vinay9738 - Friday, October 31, 2014 6:26 AM | Last reply by Chongtham Rajen Singh - Friday, October 31, 2014 3:35 PM -
0 Votes
how to extract column names and table names to listbox or combobox in vba?
Inside an Excel workbook we have sheets, every sheet has columns and rows and each cell can contain anything.Answered | 8 Replies | 4659 Views | Created by MicoVBATech - Saturday, August 23, 2014 2:19 PM | Last reply by MicoVBATech - Sunday, August 24, 2014 1:24 PM -
0 Votes
Read excell file column name
VS2010 project shows how to get column information including name.Answered | 3 Replies | 1836 Views | Created by Noor_29 - Saturday, February 2, 2013 5:34 AM | Last reply by Paul P Clement IV - Tuesday, February 5, 2013 2:49 PM -
0 Votes
Excel source with Dynamic Column Name
would I change the Month Name as Per my Excel sheet in Month Column of SQL Table ,because Every year Excel sheet Month column will start from ...Answered | 18 Replies | 7093 Views | Created by MS308 - Tuesday, January 3, 2012 7:31 AM | Last reply by MS308 - Thursday, January 5, 2012 4:08 PM -
0 Votes
how to get list of column in a table
For Your second question: Supposing Your first table name is MyFirstTable and second table is MySecondTable having columns Col1 (which stores ...Answered | 3 Replies | 4432 Views | Created by devpan - Wednesday, August 12, 2009 8:47 AM | Last reply by Piotr Katny - Wednesday, August 12, 2009 9:15 AM -
2 Votes
One Excel file has different column name
Hi Naomi, We can load multiple Excel files into source table using dynamic excel path.Answered | 3 Replies | 745 Views | Created by Naomi N - Friday, March 20, 2020 4:43 AM | Last reply by Naomi N - Friday, March 20, 2020 1:28 PM -
0 Votes
how to move rows to columns using vb.net
>>how to move values into "move to column labels" using vb.net According to your description, you could record a macro, when you record a ...Answered | 2 Replies | 985 Views | Created by Appaji - Wednesday, December 23, 2015 6:53 PM | Last reply by David_JunFeng - Friday, December 25, 2015 1:50 AM -
0 Votes
How to get Column Group Name
What do you mean by a column group name?Answered | 4 Replies | 949 Views | Created by wpf_xam1 - Thursday, September 1, 2016 1:44 PM | Last reply by Zhanglong Wu - Friday, September 2, 2016 1:21 AM -
0 Votes
OPENROWSET getting column names
I would suspect though, that you need to look for a different solution, like writing an application (or an Excel macro) that reads the Excel book and which is ...Answered | 5 Replies | 13723 Views | Created by ChronisK - Tuesday, October 26, 2010 1:05 PM | Last reply by Ai-hua Qiu - Friday, October 29, 2010 7:21 AM -
0 Votes
Help getting table and column names
Try looking here:Answered | 2 Replies | 615 Views | Created by Nick1990_K - Tuesday, July 21, 2015 3:05 PM | Last reply by Daniel Janik - Tuesday, July 21, 2015 5:28 PM -
0 Votes
How to get The name of Columns
From something I posted the other day: Dim cList As New List(Of String) ' For Each column As DataColumn In ...Answered | 1 Replies | 1132 Views | Created by Get the name of Columns - Friday, November 16, 2012 12:04 AM | Last reply by Frank L. Smith - Friday, November 16, 2012 12:14 AM -
10 Votes
Adding Column to existing table with variable column name
how is it different from adding a column every day?Answered | 15 Replies | 8729 Views | Created by Rahul Kumar (Rahul Vairagi) - Thursday, May 17, 2012 11:35 AM | Last reply by Erland Sommarskog - Friday, May 18, 2012 9:31 AM -
0 Votes
How to load data from different excel files with varying column names to a sql server table
If the structure of some excel files (column name and column number) are same, then you can use those files inside one dataflow task and then ...Answered | 7 Replies | 4388 Views | Created by BijuBalan - Thursday, September 17, 2009 8:24 AM | Last reply by Nitesh Rai - Thursday, September 17, 2009 10:42 AM - Items 1 to 20 of 3466396 Next ›
No announcements
