Last post Jan 24, 2019 05:28 AM by Ackerly Xu
Jan 23, 2019 08:50 AM|robby32|LINK
can i import a xlxs file to sql and let the schema be created dynamically, that is not creat the table in the db first , using c#?
Jan 23, 2019 11:52 AM|PatriceSc|LINK
Likely not the easiest approach and the account under which it runs will need to be allowed to create a table. This is done usually with SELECT * INTO Destination FROM Source.
Jan 24, 2019 05:28 AM|Ackerly Xu|LINK
You could also use ssms import data wizard to import excel data.
Please refer to the link below for step by step guide.
For more ways to import data, you could refer to