That's it is a nutshell! On Tue, Sep 6, 2011 at 6:52 PM, Jarvis, Matthew <mat...@mckweb.com> wrote: >> -----Original Message----- >> From: profoxtech-boun...@leafe.com > [mailto:profoxtech-boun...@leafe.com] >> On Behalf Of Lew Schwartz >> Sent: Tuesday, September 06, 2011 3:30 PM >> To: profoxt...@leafe.com >> Subject: MS Access quirky import >> >> I generate some dbf's and xml's for one of my endusers to import. >> Unfortunately, this is an MS Access (only) user and blank/empty >> strings are universally imported as Access nulls (by which I think she >> means 0 length strings). She has to concatenate several columns to >> create a key to work with, but the 0 length columns - all significant >> from a data standpoint - throw everything off. I'm not able to push >> filler characters into the data because other users need it as is. >> >> Surely there's a workaround for this, but what is it? >> > > Lew- > > So you are saying that you want to leave your system as-is, but > configure the one client w/ MS Access so that it will deal with the > nulls in such a way that it can then combine the columns in order to > form a usable key? (whew - that was a long one) > > I am searching thru access for how to configure for NULL and not really > comimg up with much... it might be something you would have to do w/ a > macro or switchboard or something so you can throw some code into the > middle of the import process, rather than just a File->Open or > something... > > > > Thanks, > > Matthew Jarvis || Business Systems Analyst > IT Department > McKenzie-Willamette Medical Center > 1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax: > 541-744-6145 > -------------------------------------------------------------------------- > Disclaimer: This electronic message may contain information that is > Proprietary, Confidential, or legally privileged or protected. It > is intended only for the use of the individual(s) and entity named > in the message. If you are not an intended recipient of this > message, please notify the sender immediately and delete the > material from your computer. Do not deliver, distribute or copy > this message and do not disclose its contents or take any action in > reliance on the information it contains. > [excessive quoting removed by server]
_______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cafuu78fa0ffnkph33+jwebssbhsphcbs9zxxkd8ne51ochp...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
