Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Importing Excel w/linked sheets through ODBC
2 views
Skip to first unread message
Scott Fox
Sep 20, 2001, 12:23:12 PM9/20/01
to
I am using SQL Server 7.0. I need to setup a program that will import
data from an Excel Spreadsheet. My problem is that the Excel sheet
contains links to other Excel sheets. If I open the sheet directly with
Excel, the values will get updated automatically. If I use ODBC or SQL
Server to import the data, it does not update the values from the linked
sheets before importing. In order to get it to work, I first have to
open the Excel sheet manually and then save it.
data from an Excel Spreadsheet. My problem is that the Excel sheet
contains links to other Excel sheets. If I open the sheet directly with
Excel, the values will get updated automatically. If I use ODBC or SQL
Server to import the data, it does not update the values from the linked
sheets before importing. In order to get it to work, I first have to
open the Excel sheet manually and then save it.
Is there a way to get SQL Server or ODBC to update the links
automatically before importing the data?
Thanks.
Scott Fox
Systems Analyst
Paul Ivanore
Sep 27, 2001, 1:38:50 PM9/27/01
to
can you open then excel document first then import it...
"Scott Fox" <scot...@ambitlink.net> wrote in message
news:3BAA17F0...@ambitlink.net...
SUNIL
Sep 27, 2001, 4:10:22 PM9/27/01
to
You can use SP_OACREATE, sp_oadestroy and other ole automation functions in
sql server to open the excel sheet (this will automatically update the excel
sheet with values) and save it as a different name. Then you can import the
data from it.
Thanks
Sunil.
sql server to open the excel sheet (this will automatically update the excel
sheet with values) and save it as a different name. Then you can import the
data from it.
Thanks
Sunil.
Paul Ivanore <notup...@hotmail.com> wrote in message
news:Oqwf#s3RBHA.1972@tkmsftngp05...
0 new messages