Connard!

CheeseEatingSurrenderMonkey

You need to change the extended properties on your Excel connection - as a default excel will check the first 8 (ish) rows of data to guess datatype etc.

Many thanks to all concerned for your input

I'm not - as I said - this is code from Microsoft which I posted as an example

From the look of it, this is just to insert a blank line...

You need to iterate through the Errors collection of the connection you are using - this code from MSDN loops through the error collection of a connection called cn and...

You can update and insert to views - I do it regularly, but the underlying table must have a unique index to be updatable

jwellington (9/22/2009)

---

Thanks for your reply Chris, but I think the solution you gave may be for Bound controls (unless I misunderstood).

I am looking to implement unbound controls where they are...

oops - duplicate post

This routine does it automatically for you - make the name of the control the same as the related column in the returned recordset, and put the word "Load" in...

When I tried it last week, it was inserting into an empty table with no indexes. Today I was working with a copy of the real data.

It was running...

In the BeforeUpdate event, you check the fields and issue a cancel i it fails your validation

e.g.

Private Sub Form_BeforeUpdate(Cancel As Integer)

IF NZ(Me.txtDate,"") = "" then

Msgbox "You...

I have just tried both your and my procedures on a copy of my live database with the following results:

My procedure - 500,000 records - 1m 27s

Your procedure - 500,000...

Jeff

You are correct in your guess about the udfFormatInt function:

CREATE FUNCTION dbo.udfFormatInt

(@input_number AS INT

, @length as INT)

RETURNS VARCHAR(50)

AS

/*

* FUNCTION NAME

* ...

Thank you very much - just what I needed!

I wrote the following stored procedure - it created 2.75m records in 32 seconds!

CREATE PROCEDURE dbo.uspInsertSerials

(

@StartNumber Int,

@Qty int,

@ExpiryDate SmallDateTime

)

AS

DECLARE @strSQL Varchar(255)

--=============================================================================

-- ...