How to insert null values in MSAccess.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

ASP.NET

How to insert null values in MSAccess.

Author

Topic

roxcy
Yak Posting Veteran

58 Posts

Posted - 2007-07-13 : 03:52:55

Hi,
i am importing data fromm excel to access using vb.net.How can I insert null values to access Table.Following is my code.



strSql2 = " Insert into DETAILS([claimid],[partid])" values & _
                                        " '" & dtCSV2.Rows(i).Item(1) & "', " & _
                                        " '" & dtCSV2.Rows(i).Item(2) & "', " & _

Please help me..
Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-07-13 : 05:20:39

Use the ISNULL or IIF function.

Peter Larsson
Helsingborg, Sweden

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-07-13 : 08:06:15

why do you want to insert NULL value?
If the cell value is NULL, it will be imported as NULL

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources