MS Access 2007 Import Problem

[Craig Tooker]

On 5/13/13 14:10, Matt Sherrill wrote:
> Hi All!
>
> For years, I've been using an Access Macro to import a FilePro exported text file to a predefined table.  Now all of a sudden, Access errors out on all numbers that have a comma in them.
>
>
> Nothing has changed.  There doesn't seem to be any difference if I manually import the text file, or use a Macro.
Of course it worked on Friday and without any changes to the underlying 
code or systems on Monday it did not work.  Highly unlikely.  Something 
changed.  This not being an Access mailing list you might be best 
advised to seek help from those who know your environment.

You could of course, define dummy variables using xx(n,.d) for each of 
your currency fields and they would be exported without any commas.  
Absent your data entry clerks entering the data with commas, those 
fields must now be defined as xx(n,,d).  In the output processing 
associated with the export, just define a decimal dummy for each 
currency field, assign the dummy from the real and then export the dummy 
instead of the real.

You could also use "doedit()" if you felt strongly that dummies are for 
dummies :)

One might ask why anyone would permanently store data in a currency 
field as it just wastes space.  You may find that the export process is 
using dummies (of the currency type) now to create the comma variety.  
In that case just change the definition of those dummy variables to the 
decimal type and Bob's your uncle.
>
>
> Upon completion of the Access Import, any number with a comma fails to import (Type Conversion Failure).
>
>
> I have also tried to allow Access to pick and choose the appropriate data type for each field by importing the text file - without any Import Specification.  And allowed Access to create a new table.  Access still errors out on any number with a comma in it.
>
> Either I need to fix the Access Import procedure or figure out a way to export the FilePro number fields - without - commas.
>
> I can't change the definition of the FilePro number fields.
>
> Thanks in advance for your help.
>
> Matt Sherrill
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20130513/5c0fb25e/attachment.html
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list