[mso] Re: Importing Excel to Access + Empty fields in a CSV file
- From: "Glenda Wells" <gwells@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 16 Aug 2005 13:54:41 -0400
Hi Andrew. I'm interested in the part of your process that "rearranges
data from another workbook..." How is that set up? /glenda=20
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Andrew Kendon
Sent: Tuesday, August 16, 2005 12:58 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Importing Excel to Access + Empty fields in a CSV
file
Just for the record, this error also occurs when you try to import into
a table which is related to another on one of the fields imported ...
and there are no matching records in the other table.
I recently puzzled for hours about two records which imported fine into
my test Results table (with the same structure as the real one) but
would not go into the real one (which was linked on Client_ID). We had
forgotton to enter those two clients into the Client table!
*** Which brings me to my question:
The data I import comes from an Excel workbook which rearranges data
from another workbook so that it is suitable for import to the Access
database.
The sheet in question has about 50 rows of formulae which produce blank
cells if there happens to be no data to convert. When I save this as a
.csv file, I get rows of empty commas corresponding to the blank rows
which I then have to edit out in Notepad. Excel is obviously detecting
something, albeit null values (""), in each cell.
Is there any way I can get my .csv to contain only rows which actually
contain data?
Andrew=20
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx
> [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Glenda Wells
> Sent: 16 August 2005 17:28
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Re: Importing Excel to Access
>=20
> I already did that and copy/paste. Both worked.
>=20
> Found the problem... The columns need to be named EXACTLY the same
>=20
> Date of Inq is NOT the same as Date_of_Inq damned
>=20
> curse the underbars :( /g=3D20
>=20
=09
___________________________________________________________
To help you stay safe and secure online, we've developed the all new
Yahoo! Security Centre. http://uk.security.yahoo.com
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will
also allow you to change your email settings to digest or vacation (no
mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions. Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
