ASCII Help

  • Thread starter Thread starter mattc66 via AccessMonster.com
  • Start date Start date
M

mattc66 via AccessMonster.com

HI All,

I have an ASCII file that I import daily and I need help in avoiding the
Comma Deliminated issue I run into.

If a user inputs a quote in the description my import will generate an error
and not import the data correctly.

How can I force Access to ignor the single quote or some how clean up the
data before I import it?

Thanks
Matt
 
Is the file in a consistent format? If so, you can create an Import
Specification that specifies data types and lengths. The specification can
be given a name and then used in code. Try importing the text file and using
the Advanced... button to do this. HTH.
 
I am using the Advance Import functions. It still fails if a " is used in the
descrption.
Is the file in a consistent format? If so, you can create an Import
Specification that specifies data types and lengths. The specification can
be given a name and then used in code. Try importing the text file and using
the Advanced... button to do this. HTH.
HI All,
Click to expand...
[quoted text clipped - 9 lines]
Thanks
Matt
Click to expand...
Click to expand...
 
All that should be needed is to set the Text Qualifier option in the
import wizard to {None}.

I am using the Advance Import functions. It still fails if a " is used in the
descrption.
Is the file in a consistent format? If so, you can create an Import
Specification that specifies data types and lengths. The specification can
be given a name and then used in code. Try importing the text file and using
the Advanced... button to do this. HTH.
HI All,
Click to expand...
[quoted text clipped - 9 lines]
Thanks
Matt
Click to expand...
Click to expand...
Click to expand...
 
Back
Top