By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,497 Members | 2,113 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,497 IT Pros & Developers. It's quick & easy.

How to replace empty cells in Access by NaN or -99

P: n/a
Hi,
I am currently working on huge files imported into Access (1.5 Go in
total splitted in 12 files). It is climatic datasets, and there is
emply cells. i would like to find a easy way to replace all theses
empty celle by a value (NaN or -99) in order to export theses files in
Matlab or to work with C

Thank you very much !

Feb 23 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 22 Feb 2007 18:36:05 -0800, "ytramblay" <yt*******@hotmail.com>
wrote:

No idea what a Go is.
Empty cells: that sounds like they have Null values. I'm sure Matlab
can work with that.
The programming language C? Superseded.

-Tom.

>Hi,
I am currently working on huge files imported into Access (1.5 Go in
total splitted in 12 files). It is climatic datasets, and there is
emply cells. i would like to find a easy way to replace all theses
empty celle by a value (NaN or -99) in order to export theses files in
Matlab or to work with C

Thank you very much !
Feb 23 '07 #2

P: n/a
Tom van Stiphout <no*************@cox.netwrote in
news:sr********************************@4ax.com:
On 22 Feb 2007 18:36:05 -0800, "ytramblay"
<yt*******@hotmail.comwrote:

No idea what a Go is.
Tom,

GigaOctet. Frencg for GigaByte
ytramblay.

You need to create update then run queries that update a field with
your choice of NaN or -99 where the field is Null.

I know this is an english newsgroup, but.
Tu dois créer des requetes qui mettront tes valeurs choisies ou le
champ est nulle.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Feb 23 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.