MS Access setting to ignore date conversion error -


an access db imports fixed width text file; 1 column dates. when date not available, file's creator uses string "null" access puts row in table field null.

but, when files started coming different field widths, copied db, tweaked starting/width values in input spec, , imported. now, rows null logging in (table)_import_errors error converting text date.

i have found no setting (not changed any) explain it. 1 difference although both dbs in access 2000 format, original on machine still has access 2000, while new 1 being handled access 2003.

is behavior change in access version? pre-processing file solution?

thanks, david. that's have done (except excel part) if had not fixed itself. posted that, apparently didn't public admission access has bugs.

the thing changed 2 other columns in fixed width plain text input wider. yet access "decided" discard whole row instead of date field 3 consecutive attempts. fourth time, still reported error imported rest of row.

so, when access misbehaves no reason, try again time or two, try explicitly coding conversion text.

two possibilities:

  1. use buffer field or buffer table imports date field text field. can process appropriate values in final destination field.

  2. use sql import instead of docmd.transfertext. in case use connect string in clause can process date field in select:

  select sheet1.firstfield, replace(sheet2.datefield, "null", null) datefield    sheet1 in 'c:\import\spreadsheet.xls'[excel 5.0;hdr=yes;imex=1;];

convert insert query , you're golden.


Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more