The columns that you are trying to write '51,00', '0', '102,00' are set-up as MONEY.  They will not auto-change '51,00' from a CHARACTER into MONEY.

You can either do 51, 0,...

Research ADODB parameters.  There is decent help for them online and in the HELP file.

I would look at Red Gates SQL Compare

Why not create a table that first examines the table you are going to pull data from and populate a MAX VARIABLE with the # of records.

Then create a TEMP...

If you are storing the SOLD as DATETIME the below may help

DECLARE @VAR DATETIME

SET     @VAR = '2005-07-13 05:42:08.070'

SELECT CONVERT(CHAR(10), @VAR, 101) + SPACE(1) + LEFT(CONVERT(CHAR(8), @VAR, 108), 2) + ':00'...

I would research @@IDENTITY/SCOPE_IDENTITY() in BOL.  Partial from BOL

SELECT SCOPE_IDENTITY() AS [SCOPE_IDENTITY]

GO

SELECT   @@IDENTITY AS [@@IDENTITY]

GO

--Here is the result set.

SCOPE_IDENTITY

4

/*SCOPE_IDENTITY returned the last identity value in the same scope, which was...

You don't need to apply any service packs or hotfixes for this environment.  Luckily, AMD 64 bit handles 32 bit all by itself (AFAIK there is nothing you could anyway). ...

Start with MS Inside SQL Server 2000.

Other books to read:  Sit at local bookstore.  Grab books about SQL.  Whichever ones don't put you to sleep and hold your interest buy.

Without knowing the motivation of the poster of the above quote I can only hazard the following:

Access is GREAT at providing quick, dirty, small applications rapidly.  I don't think that...

I actually didn't realize how close I was guess tomorow will be the big K...

I apologize for my narrow thinking on this one Remi.  I ASSumed US-ONLY based on the sample.  You are absolutely correct that my sample WOULD NOT wokr in Europe.

David,

You are absolutely correct.  IF you UPDATE/INSERT spaces into a VARCHAR field THEN they will be there.  I was thinking more in terms of UPDATE/INSERT "Smith" which would not...

Why not use UPDATE table SET Column = LEFT(Column, 5) ?

Can you post the field definition?  That may go a long way of explaining the problem.  If it is CHAR then you will ALWAYS have spaces if VARCHAR then you...

short answer is CRYSTAL is a HUGE pain in the @&$&Y and NO, unfortunately, not.