lunchbox88
Programmer
I'm having an issue filling a dataset from an excel file.
Creates an OleDB connection to the spreadsheet (no problem), then generates a Select statement to read the worksheet in to the dataset.
It works great IF all the relevant fields in the spreadsheet contain data.
The select is a simple "Select * from [worksheet]". And it's been working great except that one of the new files has optional fields.
In the past I've used isnull(field,default value), but that's been when the data source is static, and I know what fields I'll be reading in.
How can I check for nulls in a select * query?
Thanks!
Creates an OleDB connection to the spreadsheet (no problem), then generates a Select statement to read the worksheet in to the dataset.
It works great IF all the relevant fields in the spreadsheet contain data.
The select is a simple "Select * from [worksheet]". And it's been working great except that one of the new files has optional fields.
In the past I've used isnull(field,default value), but that's been when the data source is static, and I know what fields I'll be reading in.
How can I check for nulls in a select * query?
Thanks!