importing an xlm file into a new MS SQL Server table
Hi there,
I have the below type of data that is in a xlm file. What I will like to do is to import all the columns with all the data into a new sql table. I don't know how to go about importing a xlm file into a new sql table. If someone can provide me a sql script that I can use to import this data it will be most appreciated.
XLM file is attaced as a zip file. There are many columns and will like to have each column along with the data in a nice formatted table. This file a constantly being updated and will like if possible to have sql access this file in real time if not a script to have sql refresh the table every 2 minutes or so will also suffice.
Please note the most important thing that I need at this time is the importation and parsing of the data into readable information. Anything additional is a bonus but not a must at this time.
Any help will be most appreciated. Attached is a text file with the xlm data