April 6th, 2004, 03:42 AM
|
|
Registered User
|
|
Join Date: Apr 2004
Location: England, London
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Linked Server to excel.
Hi. I have a little(hopefully) but very annoying problem.
If you create a linked server to the excel file with let say "three columns" (eg. in fields A1 'ID', B1 'Name', C1 'Telephone'), and then you'll query (select * from srvName...[SheetName$] you'll see fields ID, Name, Telephone with data filled below. Now if you connect an empty excel file you'll see only one column named F1. 
Now. How to create column names (insert any text in fields A1, B1, C1) in empty excel sheet? On the server where SQL is installed there is no Excel or Office installed. But there is an empty excel file and linked server connected to it.
Pleeeezzz help 
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
