Hi David.   Me again (sorry).

I tried the format file, with contents exactly as follows: -

8.0

1

1  SQLCHAR  0  2500  "\r\n"  2  Data  SQL_Latin1_General 

(as per the BOL example for 3 columns in...

Hi David.    I did exactly as you suggested, but  received the following error message: -

"Server: Msg 4839, Level 16, State 1, Line 1

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot perform bulk insert....

Thanks again, David.   It just sounds too easy, but I'll run it in the morning now.

Cheers,

Lester Vincent    

Thanks David.  Sounds logical.   It's getting late here, (Sydney time), so I will try your suggestion in the morning.

I have never created a format file, and am not sure how...

Hi Dick and Charles.  I have tried twice (Satruday and today) to post a reply to you, but each time it has failed.     Don't know why this is happening.     This...

Thank you, Marshall and Michael.    I will keep working at it, and will advise the outcome.

I have to stay with the Access .mdb front-end at this stage.   Maybe the answer...

Thank you, Mike.    I was not thinking of a drill-down so much as a simple main report with two levels of nested sub-reports.  But I didn't know click events existed...

Thanks Rodney.   We're all friends here, as far as date format goes.   I notice Sergiy is a kiwi, you're from the UK, and I'm in Aussieland.

As far as the date...

Thanks Rodney.   I appreciate your input on this and take your point regarding data type declaration.  (The optionality is something I picked up from a text on SQLS2K.

I think I...

Thanks Rodney.

(What you have stated suggests there was nothing wrong with the way I had originally written the CAST statements.)

What I'd really like to discover is why the SPROC aborts...

Sergiy,

I have double-checked and the SPROC contains no instances of PRINT or CAST.

The error message still occurs and the SPROC aborts on debugging in Query Analyser.

So I am still stuck...

Hi Sergy.      Yes, I did use this format at first.

Something like

PRINT 'Number of rows='+ CAST(@intRows as varchar(3))

(which I think is wrong, because it contains the "(3)" value and CAST...

Just as a quick follow-up, Andy. (What a great discussion on this point!   Very helpful.)

I have chosen to create an unlinked MDB file, using ADO Commands to drive the Stored procs,...

Fantastic article, Andy!   I guess you would not recommend to have a lot of links like this concurrently across the network.   I am currently working the other way, transforming an Access 2K...

Thank you, John.   Nothing has work so far for me, and I welcome your reply. 

I will follow up on your advice and will let you know the result.

I have some...