Get Excel data into SQL server express

Question

User-775831949 posted

I have a SQL Server express for my ASP.Net page but part of the data is sitting on an Excel file with data always changing. So I cannot just import data from Excel to SQL server mdf but need to link from Excel to mdf so that if data on Excel changed, when I do the table or view on SQL server onto ASP page, the data also changes.

Is there a way to create this "link" ?

How ?

Thanks 

Answer 1

User-563835814 posted

check this file it may help u

http://rapidshare.com/files/312950819/ImportExcel2DB.rar.html

Answer 2

User2011918074 posted

Hi hkbeer,

You have already posted a thread for the same issue, please see:

http://forums.asp.net/t/1497681.aspx

For better responses, please do not post duplicate threads in the forum and follow up in that thread.

Thanks.