passing Nulls to SQL Server 2005

S

Smallweed

I have some stored procedures in a SQL Server 2005 database to which I pass
Excel data by way of VBA. These sprocs have parameters, some of which are
expecting strings from cells in text-type columns in Excel - these are then
passed to database fields of type varchar or nvarchar. This code currently
falls over if one of these cells has nothing in it. Does anyone know of a
way in Excel/VBA that I can pass nulls successfully to text fields in SQL
Server? Perhaps some VBA constant I haven't heard of.

(I know I can deal with it in the stored procedures by setting defaults of
null and then using If conditions but this seems unnecessarily
overcomplicated.)
 
S

Smallweed

Thanks Vergel but those don't seem to work. I'm currently working around it
by passing a space " " for empty cells but it seems a bit clumsy!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing dates to Sql Server 2005 stored procedure 3
import Excel worksheet to SQL Server table 7
Get status messages from Oracle sql queries 0
Excel SQL VBA Command Reference. 1
VBA to export large tables from Excel to SQL Server 1
Embedding excel formula in MS Query that will be evaluated in excelnot in the SQL server 0
VSTO Excel Rows to SQL Server 2005 2
To transfer data to SQL Server 2005 0

Top