473,657 Members | 2,690 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how to fill in blanks after an xcel import

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
1 1705
found my own answer,

WHERE column is null
"Steve" <1@2.com> wrote in message
news:k0******** *********@newsr ead2.news.atl.e arthlink.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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2143
by: samlicon | last post by:
i have a java project to do , but what problem i encounter is how to fill / put an image of jpeg into a Reatangle in the code below please type the code in detail since i am an entry level students thanks a lot the code Listed below
1
1491
by: ben | last post by:
I am working on a classic ASP application. This application needs to run an SQL query and take the result set and stream it into an XCEL spreadsheet for processsing by the users. Is there an ASP method of third party product to do this?
1
1685
by: William.R.Reisen | last post by:
Hi, I have currently in Xcel and long list of X English phrases in one column with associated numerical data about each name in adjoining columns. I have on another workbook (which could of course be pasted into this workbook)another similarly set out column of Y English phrases again with ajoining columns having numberical data row that the phrase.
1
3188
by: Stephen H | last post by:
I'm a newbie to writing and running code in MS Access so the more detail the better for me when answering. Thanks. My Problem ( Or Challange , I should say ) is that I import a csv file into an access table called 'booked' ; one of these fields is called "job". Now when this import happens there are a lot of records that are blank. I need to populate these fields with the previous records' value. ie. ( I am substituting in a "-" for a ...
2
1880
by: brian_harris | last post by:
I have a 3rd party unmanged .dll. This has functions that will look up information and fill a C string passed to it with data. I want to use this data in .NET classes after it has been filled and I am programming in C++. I believe that I should use pinvoke, but I see a problem that I can't figure how to get around. I don't think I can declare the string I want as a String class since when I pass it to unmanged function it is not yet...
1
11560
by: tom c | last post by:
I am using Visual Web Developer 2005 Express Edition. I created a SQLDataSource just by draging the control to the form and filling in the blanks in the wizard. In code I need to use the SQLDataSource to load data from several tables into datasets or datatables, work with the data, then insert new rows into tables in the SQL Server database. I can not find any example code showing me how to do this. I don't even see any example...
34
4092
by: Registered User | last post by:
Hi experts, I'm trying to write a program that replaces two or more consecutive blanks in a string by a single blank. Here's what I did: #include <stdio.h> #include <string.h> #define MAX 80
3
10280
by: ravibantu | last post by:
Hi guys, I am a newbie to python. Does anybody know how i can read a dat file into python and convert into xcel format? Thank you ravi
1
2083
by: 2D Rick | last post by:
I imported a text file that lacks a "Part Number" for each record. Each blank below a given "Part Number" should have the same "Part Number" until the next "Part Number". How can I fill in the blanks? Sample table below: Part Number PO Number Item 3827092-111 G00026664 1110 G00026664 1181
0
8306
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8825
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
7327
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6164
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4152
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4304
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2726
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1955
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1615
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.