<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt">Kenneth,<br> I'm guessing one of the myriad Microsoft updates changed MS Office - which changed Access.<br><br>I'm going to try to fix it your way on the export. Currently the field edit is setup as "nn,nnn,nnn,nnn". I'm going to see if I can change it to NOT include the commas.<br><br>Thanks,<br><br>Matt<br><br><div><br></div> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font face="Arial" size="2"> <b><span style="font-weight:bold;">From:</span></b> Kenneth Brody <kenbrody@spamcop.net><br> <b><span style="font-weight: bold;">To:</span></b> Matt Sherrill <mmsv45@yahoo.com> <br><b><span style="font-weight: bold;">Cc:</span></b>
"filepro-list@lists.celestial.com" <filepro-list@lists.celestial.com> <br> <b><span style="font-weight: bold;">Sent:</span></b> Monday, May 13, 2013 2:45 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: MS Access 2007 Import Problem<br> </font> </div> <div class="y_msg_container"><br>On 5/13/2013 2:10 PM, Matt Sherrill wrote:<br>> Hi All!<br>><br>> For years, I've been using an Access Macro to import a FilePro exported<br>> text file to a predefined table. Now all of a sudden, Access errors out<br>> on all numbers that have a comma in them.<br>><br>> Nothing has changed. There doesn't seem to be any difference if I<br>> manually import the text file, or use a Macro.<br>><br>> Upon completion of the Access Import, any number with a comma fails to<br>> import (Type Conversion Failure).<br><br>Well, obviously *something* has changed.<br><br>Have the filePro numbers always had commas in
them? Have you upgraded Access <br>recently?<br><br>[...]<br>> Either I need to fix the Access Import procedure or figure out a way to<br>> export the FilePro number fields - without - commas.<br>><br>> I can't change the definition of the FilePro number fields.<br>[...]<br><br>Well, without knowing anything about your file or the export, I can tell you <br>that you can eliminate the commas from the fields by using DOEDIT() to <br>convert the number to a non-comma version.<br><br>For example, if you have a ",2" field, you could convert it to a ".2" using <br>something like:<br><br>Change<br><br> myexport(3) = ytd_sales<br><br>to<br><br> myexport(3) = doedit(ytd_sales,".2")<br><br><br>-- <br>Kenneth Brody<br><br><br></div> </div> </div> </div></body></html>