[mso] Re: Importing Excel to Access + Empty fields in a CSV file
- From: "Andrew Kendon" <tyto2820@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 16 Aug 2005 17:57:38 +0100
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
> -----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
>
> I already did that and copy/paste. Both worked.
>
> Found the problem... The columns need to be named EXACTLY the same
>
> Date of Inq is NOT the same as Date_of_Inq damned
>
> curse the underbars :( /g=20
>
___________________________________________________________
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
*************************************************************
Other related posts:
