Hi, is it possible to link to an Excel file from my computer to my SQL database (Winhost)? I tried to Import Excel spreadsheet data with SQL Server Management Studio and it works great Well, I need to changes in Excel file, locally, automatically transferred (updated) on a linked table in SQL DB. This is the logic of linking Excel spreadsheet and Access, with which I am familiar - so I need to know whether this is possible or whether it is allowed on Winhost. Before I start learning how to do that Thanks
Please see the following link: http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=135 You can use the Import/Export option to move data, and VBA should work. We do not, however, support the OPENROWSET function or linked servers.
Elshadriel, thanks for reply, may I ask same question for MySQL server. Can we link Excel with MySQL DB ? Maybe a different approach, I guess it's possible: Run Import query once and than run a update query with timer based on excel data, in SQL Studio, automatically upload or save excel file through FTP and then call it in update panel with a timer, or ... any suggestion ? PS. I did not need to manipulate data, but only to show them on my asp page as table or formatted text ...