I have tried that, with no help.

DECLARE @status int EXEC

@status = sp_check_Import_Table_Stores 'Stores_Import' SELECT @status AS Status

Do I put the transaction isolation level before the start of the transaction, or right after?

thanks for the help. unfortunatly, i do not have the whole suite of crystal applications. my boss just wants some stuff to show him the benefit of data...

I am sorry, but my lack of knowledge in VB won't allow me to understand any of that script on Microsoft's website. What is it supposed to do, and...

Ok, i have gotten the script down to

Set conn = CreateObject("ADODB.Connection")

conn.Provider = "Microsoft.Jet.OLEDB.4.0"

conn.Open = "\\slsben01\DvlpApps\Data\WMTBW\WMTBW_Stores.csv"

Unfortunatly, i get an error back saying that my csv file is an unrecognized format to...

A lot of commands i have seen also have this:

Set cnn = New ADODB.Connection

well, i am not opening a Database, so i would suspect the ADOBD command dosn't work. ...

I have a querry that puts data in my text file, all i need to do is append a series of numbers to it that represents the week. I...