ASCII Help

[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

 

[kingston via AccessMonster.com]

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.

 

[mattc66 via AccessMonster.com]

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,

[quoted text clipped - 9 lines]

Thanks
Matt

 

[John Nurick]

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,

[quoted text clipped - 9 lines]

Thanks
Matt