MS Access 2007 Import Problem

[Matt Sherrill]

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.


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