September 9, 2014 at 11:11 am
I have to load multiple excel files into a single table (which has 50 columns (ntext)), but an excel file can contain any number of columns but less than 50 columns.
Example:
ExcelFile1: has 20 columns with 15 rows
ExcelFile2: has 12 columns with 10 rows
If we load above two files into a single table, the table should contain total 25 rows(first 15 rows with 20 columns and 10 rows with 12 columns)
Thank you
September 9, 2014 at 11:30 am
First, you made a simple statement with your post but didn't ask any question.
Second, you posted this in another section of the forum. Do not make multiple posts for the same thing.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 9, 2014 at 11:35 am
Closing.
Pls post replies here: http://qa.sqlservercentral.com/Forums/Topic1611892-364-1.aspx
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply