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

how to fill in blanks after an xcel import

P: n/a
I imported data from a spreadsheet into an access table. is there a way to
deal with the empty cells? currently they are empty fields but I dont know
how to interact with them.
This is my first crack at a database and have modified the initial table
alot already in preparing to break it into a bunch of smaller tables. I am
hoping I dont need to modify the spreadsheet, and then reimport.
I would like to run some sort of an update that would fill the blanks of
certain columns with n/a but I dont know what to equate the ?? below too.

UPDATE [table]
SET column = 'n/a/'
WHERE column = ??;

?? is the contents of an empty field
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
found my own answer,

WHERE column is null
"Steve" <1@2.com> wrote in message
news:k0*****************@newsread2.news.atl.earthl ink.net...
I imported data from a spreadsheet into an access table. is there a way to
deal with the empty cells? currently they are empty fields but I dont know
how to interact with them.
This is my first crack at a database and have modified the initial table
alot already in preparing to break it into a bunch of smaller tables. I am
hoping I dont need to modify the spreadsheet, and then reimport.
I would like to run some sort of an update that would fill the blanks of
certain columns with n/a but I dont know what to equate the ?? below too.

UPDATE [table]
SET column = 'n/a/'
WHERE column = ??;

?? is the contents of an empty field

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.