Today I used Data Transformation Services (DTS) of SQL Server 2000 to populate a table in the SQl Server database from an excel file. This was an easy way of creating a table on the fly without bothering to create the table structure first and then populate the table with the data.
Procedure I followed was as follows:
Right click on a table or a database in the SQL Server Enterprise manager.
select Import data
Select the source as an Excel driver
select the destination as the table to be created inthe database.
Click finish and your table is ready with the data populated
Yes, it is that simple.
Subscribe to:
Post Comments (Atom)
Databases and Data Visualisations Course for kids Week 1
As mentioned last week, I have started the Databases and Data Visualisations course for kids aged between 11 to 15 years yesterday. It was...
-
I needed to convert some vbscript to javascript as firefox doesn't support vbscript. I found this online tool very helpful Beware tha...
-
This morning I was trying to call a stored procedure and insert the results in a temp table using the following code -- create table #...
-
When I tried to access the report manager after a fresh installation of Sql Server Reporting Serivces 2016 using the url http://localhost/R...
No comments:
Post a Comment