Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by flavin

  1. flavin

    Using OPENQUERY with EXCEL LinkedServer

    I have done as you said, but am still getting the same error. I selected the first row A1 to U1 which contain the column headers and added this row 1:1 in the label range of the Label Ranges dialog. Thanks, Ann
  2. flavin

    Using OPENQUERY with EXCEL LinkedServer

    Hi, I have created a linked server for an Excel worksheet as EXEC sp_addlinkedserver 'ExcelSource', 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', 'c:\aflavin\ExcelFies\SampleDatabase.xls', NULL, 'Excel 5.0' GO When trying to create a SP to pull all data from the file Server: Msg...
  3. flavin

    Using OPENQUERY with LinkedServer (Excel)

    The cells A1 to U1 are being used to hold the text that are the column headings. However they do not have any special formatting. Is it required for these cells to be formatted to make them "column headings"?
  4. flavin

    Using OPENQUERY with LinkedServer (Excel)

    I have added the remote Login but am now getting this error message. Server: Msg 7357, Level 16, State 2, Line 1 Could not process object 'SELECT * FROM DETAILS'. The OLE DB provider 'Microsoft.Jet.OLEDB.4.0' indicates that the object has no columns.
  5. flavin

    Using OPENQUERY with LinkedServer (Excel)

    Hi, I have created a linked server for an Excel worksheet as EXEC sp_addlinkedserver 'ExcelSource', 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', 'c:\aflavin\ExcelFies\SampleDatabase.xls', NULL, 'Excel 5.0' GO I now need to write a Stored Procedure that pulls all the data in the excel...
  6. flavin

    Exporting within a Stored Procedure

    Hi, I have created a linked server for an Excel worksheet as EXEC sp_addlinkedserver 'ExcelSource', 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', 'c:\aflavin\ExcelFies\SampleDatabase.xls', NULL, 'Excel 5.0' GO I now need to write a Stored Procedure that pulls all the data in the excel...
See more

Part and Inventory Search

Back
Top