I have an excel 2013 spreadsheet where I need to load data into sql server 2012 for a onetime load. I am using the data-> workbook connections -> and I am required to select a table from the database that I am pointing to. Thus to me it looks like I need to have a table created in advance on sql server 2012. It does not look like a table will automatically be created for me first based upon the columns that are in the excel spreadsheet. Is this correct? If not, can you give me directions on how I can use excel 2013 to create a table dynamically based upon the column in a particular excel spreadsheet?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Load data from excel 2013 into sql server 2012
- Thread starter scamper
- Start date
-
- Tags
- excek 2013 excel & ilogic
Similar threads
- Question
