By default the Excel ISAM examines the first eight rows and will use the majority type to determine the data type, so if the first line is alpha and the...

The problem is the Excel ISAM and it's estimating of column contents and uses the type of the majority values (and value evaluation) to decide what the column type is and...

sorry my fault, did not check parameter names properly, try this instead

exec sp_executesql @InsertString,

N'@Curcode char(3),@ExchRate char(25),@GLDesc char(100),@Glcode char(10),@debit char(25),@credit char(25),@dtmyr char(25),@crmyr char(25),

@refno char(16),@itiscode char(3),@trandesc char(100),@Createdby char(50),@trandate char(12),@batchno char(3)',...

Because the table name is not known, only the structure and therefore assumes that the structure is the same for any table name passed to the proc.

Try executing the sql by...

Didn't you ask the same question on another thread

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=234436#bm234839

Are the columns in the spreadsheet set as text?

Did you change the registry setting?

Have you tried to increase the row sampling?

See http://support.microsoft.com/kb/194124

My guess  would be

create table kpuser.tbl(Vtpe varchar(50))

declare @UnitID varchar(8000),@FieldName varchar(50),@Unit_ID varchar(30)

set @UnitID = '252,253,254,255,'

Declare @Flag int

declare @delimiter nchar(1)

set @delimiter...

In .NET the basics (using Gila's proc)

Dim param1 As SqlParameter

Dim param2 As SqlParameter

Dim CommSQL As New SqlCommand()

CommSQL.Connection = ConnSQL 'Or whatever your connections is called

CommSQL.CommandType = CommandType.StoredProcedure

CommSQL.CommandText = "Test"

CommSQL.Parameters.Clear()

param1 =...

Make sure the output field is created as LongText, this works for me

The only time I had something like this is when I had 'Set implicit_transactions' ticked in Options / Connection properties

This tells QA to start a transaction when you connect which...

But still uses a cursor

If the number of tables is not too large then you could use dynamic sql

DECLARE @sql nvarchar(4000)

SELECT @sql...

Check SERVER1 has Data Access checked in Server Options for the linked server SERVER2

That is what the REPLACE query I posted will do, try this in QA

SELECT REPLACE('A1EC1XXXXXX-52','X','')

and you will get

A1EC1-52

SELECT u.lname,t.Total,ISNULL(c.Correct,0) AS [Correct]

FROM [User] u

INNER JOIN (SELECT u.userid,COUNT(*) AS [Total]

  FROM [User] u

  INNER JOIN [Request] r ON r.userid = u.userid

  GROUP BY u.userid) t...

or

STUFF('A1EC1XXXXXX-52',6,6,'')

if they are not really X's