Access 2003

And again Thanks Greg - I found it!

Could someone give the path to this option tab?  I can't seem to find it.

thanks

Clients are gods - $$ flow from them... but life would be easier... I guess I won't go there.

Well it really is not a presentation issue since the data is being exported into a file and the client wants it right justified.  - But I get your point

Perhaps another answer... ugly but it turns it around.

Any other thoughts?

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_TABLE_COAL]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[T_TABLE_COAL]

GO

CREATE TABLE [dbo].[T_TABLE_COAL] (

 [TAB_ID]...

Is the SQL Server Enterprise edition?

Steve

Thanks that'll do it!

Good suggestions.  The code does not appear to be in VBA, it is embedded in the spreadsheet using Excel's query editor.  I do plan to move the queries to the...

Yeah, so does the SQL Server Import as long as the dBase III file has a name that is less than 8 characters!

Data has been copied into SQL Server -...

Thanks for the replies.  Turned out it was a dBase III file.

Excellent!

Thanks, that was the answer!

Steve

My solution so far is to create a table like this

CREATE TABLE [T_BAD_WORD] (

 [BAD_ID] [int] NOT NULL ,

 [BAD_WORD] [varchar] (255) NOT NULL

) ON [PRIMARY]

GO

Then Create a series of select...

Just one column and your suggestion was what I was thinking of doing.  I just didn't want reinvent the wheel if there is some useful advise.

Thanks

Steve

Yes, normally I would agree If blocks are the way to go.  In this case, though the normal run just passes through the entire Stored Procedure.  It is a series...