SQL Server Performance

Search Results

Search Again
  1. bbasir

    Openrowset (INSERT) error Insert Error: Column name or number of supplied values does not match table definition.

    Post by: bbasir, Mar 27, 2008 in forum: General Developer Questions
    Thanks Satya for your help, but in open rowset there are only two selects... 1. from the excel... select * from sheet1$ 2. from the database......
  2. bbasir

    Openrowset (INSERT) error Insert Error: Column name or number of supplied values does not match table definition.

    Post by: bbasir, Mar 26, 2008 in forum: General Developer Questions
    Thanks Satya for the reply, however how will I ntegrate the above information scheme with my Openrowset INSERT? Lets take this simple pubs database...
  3. bbasir

    Openrowset (INSERT) error Insert Error: Column name or number of supplied values does not match table definition.

    Thread by: bbasir, Mar 24, 2008, 5 replies, in forum: General Developer Questions
    Hi: I want to create teh column names dynamically from my sql that is being passed and not to hard code the column names in my template excel file....
  4. bbasir

    (OPENROWSET) Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication failed.

    Thread by: bbasir, Mar 18, 2008, 2 replies, in forum: SQL Server 2005 General Developer Questions
    Can some one tell me how to resolve this issue???? I am using sql server 2000... the procedure that I use is as below.... Server: Msg 7399, Level 16,...
Showing results 1 to 4 of 4
Search Again